like 模糊查询

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

JayPan2008

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

阅读量796

点赞数

CC 4.0 BY-SA版权

分类专栏： SQL

本文链接：https://blog.youkuaiyun.com/binzai325/article/details/7859247

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