MySQL模糊查询特殊字符如何查询？

1.关键字escape

例子：select * from user where name like "%/%%" escape "/"

2.函数 instr

例子：select * from user having  instr(name,"%")

mySQL里面locate和instr一样，好像是相同的，具体自己深入了解