like 模糊查询

最新推荐文章于 2024-10-17 10:15:00 发布

原创最新推荐文章于 2024-10-17 10:15:00 发布 · 795 阅读

0 ·

CC 4.0 BY-SA版权

SQL 专栏收录该内容

4 篇文章

订阅专栏


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]%';