模糊查询带%的用户

问题：如下sql,会把不匹配的数据查询出来

 SELECT COUNT(1) FROM cmooc_course a WHERE a.valid = 'Y' AND a.app_id = 'b504cfe76e27c640a1df1aeb244ff137' AND a.course_name LIKE concat('%', '%', '%') 

 

 

更换： like 更换 INSTR

INSTR(a.course_name,#{courseName}) <> 0


select * from emp where instr(ename, '%') <> 0

 

 

2. select * from emp where ename like ('%/%%') escape('/');