like 模糊查询

select * from student where name like  '%a%';
='%[ao]%'[]匹配其中任一字符
select * from student where name like  '%[a][o]%';
select * from student where name not like  '%a%';
select * from student where name like 'ja%';
='%[jn,]%'
select * from student where name not like '%[j,n]%'; 
='%[jna,]%'
select * from student where name like '%[j,n,a]%';
='%[^jason,]%'不包含jason,任一字符的字符串，匹配','的情况下前一种写法易读
select * from student where name like '%[^ja,as,on]%';
='%[jaon_]%'
select * from student where name like '%[ja_on]%';