34,590
社区成员
发帖
与我相关
我的任务
分享
create table Demo
(
id int identity(1,1) primary key,
name varchar(100),
tel varchar(100)
)
insert into Demo values('小明','13333332222')
insert into Demo values('小李','13833332222')
insert into Demo values('小张','15933332222')
insert into Demo values('小赵','13333338899')
insert into Demo values('小王','13888888888')
--查询号码包含2222的
select * from Demo where tel like '%2222%'
--查询手机号是133开头的
select * from Demo where tel like '133%'
--查询尾号是8899的
select * from Demo where tel like '%8899'
--查询ID在 2 3 4之间的
select * from demo where id in(2,3,4)
select * from demo where CHARINDEX('2222',tel)>0
select * from demo where left(tel,3)='133'
select * from demo where right(tel,4)='8899'
select * from demo where id=2
union all select * from demo where id=3
union all select * from demo where id=4
--查询手机号是133开头的
select * from Demo where tel >=13300000000 and tel <13400000000
select * from Demo where tel between 13300000000 and 13399999999