1.关键字escape
例子:select * from user where name like "%/%%" escape "/"
2.函数 instr
例子:select * from user having instr(name,"%")
mySQL里面locate和instr一样,好像是相同的,具体自己深入了解
3.根据创建时间分组
select substring(create_time,1,10)as date ,count(1) from user group by date;