like:进行数据模糊查询
- %:匹配0次或多次
select * from student where name like '张%’;#查询姓张的学生信息
select * from student where name like '%李%’;#查询姓名中含有“李”字的学生信息
- _:只匹配1次
select * from student where name like '张_’;#查询两个字的张姓学生信息
- escape:取消%或_字符的通配符特性
#查询姓名中含有%字符的学生信息
select * from student where name like '%#%%' escape ‘#’
#查询姓名中含有_字符的学生信息
select * from student where name like '%$_%' escape ‘$’
#查询姓名以%%结尾的学生信息
select * from student where name like '%_%_%' escape '_’;
- 注意
- escape后面单引号中只能是单个字符
- escape后面可以是字母、#、$、,、\等字符