use MySecondDb
--迷糊查询
--N : 代表匹配0个字符
--_ : 代表匹配有且只有1个字符
--[] : 代表匹配范围内
--[^] :代表匹配不在范围内
select * from People
select * from Department
select * from Rank
--查询出姓刘的员工信息
select * from People where PeopleName like '刘%'
--%代表0个字符或者多个字符
--查询出名字中含有‘亮’的员工信息
select * from People where PeopleName like '%亮%'
--查询名字中含有‘亮’或者含有‘飞’的员工信息
select * from People where PeopleName like '%亮%' or PeopleName like '%亮%'
--查询出姓刘的员工信息,名字是两个字
select * from People where PeopleName like '刘_'
select * from People where substring(PeopleName,1,1)='刘' and len(PeopleName)=2
--查询出最后一个字为亮 名字一共三个字员工信息
select * from People where PeopleName like'__亮'
select * from People where substring (PeopleName,3,1)='亮' and len(PeopleName)=3
--查询出电话号码开头为138的员工信息
select * from People where PeoplePhone like '131%'
--查询开头电话号码为138的 第四位好像是5或者是8,最后一个号码是4
select * from People where PeoplePhone like'131[5,8]%4'
--查询出电话号码开头为131的,第四位好好像是2-5之间,最后一个号码不是2和3
select * from People where PeoplePhone like '131[2,3,4,5,6]%[^2,3]'
select * from People where PeoplePhone like '131[2-5]%[^2,3]'
Sql server 模糊查询
本文介绍了如何使用SQL中的LIKE、substring和正则表达式进行模糊查询,如筛选姓氏、名字、电话号码等,以满足不同场景下的数据检索需求。
摘要由CSDN通过智能技术生成