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......
阅读全文