Question

select * from product where name like '%_%' escape '' 我想要查询name 中包含有_的应该怎么办？

Answer 1

select * from product where name like '%[_]%'
或者
select * from product where name like '%\_%' escape '\'

Answer 2

这样写应该就可以了啊
什么数据库？sqlserver、mysql还是oracle?

追问

mysql

Answer 3

select * from product where name like '%%%' escape '/';

Answer 4

select * from t where x like '%\_%' escape '\';