How to put variables in the MySQL query statement? Guys

Question

I want to use php to query the database, but I have to add a variable to the condition

"select lyrics, song title, pinyin from name where pinyin like '%$cp[a-z]%'"

In this way, an error is reported directly. If you don’t add [a-z], there is no problem, but you must add it to query. What should I do? Guys

Answer 1

In my impression, [] seems to be a regular thing. It doesn’t seem to be mentioned in the fuzzy query. You can try it

Answer 2

select lyrics, song title, pinyin from name where pinyin like '%$cp%' and pinyin REGEXP '[a-z]'