1.关键字escape
例子:select * from user where name like "%/%%" escape "/"
2.函数 instr
例子:select * from user having instr(name,"%")
mySQL里面locate和instr一样,好像是相同的,具体自己深入了解
1.关键字escape
例子:select * from user where name like "%/%%" escape "/"
2.函数 instr
例子:select * from user having instr(name,"%")
mySQL里面locate和instr一样,好像是相同的,具体自己深入了解