mysql 下划线 搜索,mysql-如何使用特殊字符％（％）和_（下划线）处理查询搜索...

I have 2 records in my database, Tom%Jerry and Ninja_Kids. One has a special character %(percent) and the other has _(underscore). I tried the following commands in mysql terminal.

SELECT * FROM CUSTOMER WHERE NAME LIKE '%%%';

SELECT * FROM CUSTOMER WHERE NAME LIKE '%_%';

Both of the commands returned all the records.

How am I gonna make these return the record that has either % or _.

I know that % is used in mysql like a reserved word but what if there are cases that a record contains special characters mentioned above.

BTW, aside from the 2 do you know other special characters that don't behave normal?

Please help. Thanks in advance.

解决方案

You need to escape % and _. The doc.

SELECT * FROM CUSTOMER WHERE NAME LIKE '%\%%';

SELECT * FROM CUSTOMER WHERE NAME LIKE '%\_%';