22,210
社区成员
发帖
与我相关
我的任务
分享
create table tab(name varchar(20))
insert into tab values('stha')
insert into tab values('sthab')
insert into tab values('sthabc')
insert into tab values('sthabcd')
insert into tab values('sthabcde')
go
select * from tab where name like 'sth___'
/*
name
--------------------
sthabc
(所影响的行数为 1 行)
*/
select * from tab where name like 'sth___%'
/*
name
--------------------
sthabc
sthabcd
sthabcde
(所影响的行数为 3 行)
*/
select * from tab where name like 'sth_'
/*
name
--------------------
stha
(所影响的行数为 1 行)
*/
select * from tab where name like 'sth_%'
/*
name
--------------------
stha
sthab
sthabc
sthabcd
sthabcde
(所影响的行数为 5 行)
*/
drop table tab
select * from tab where name like 'sth_%'