select * from table where id like 'A%' 查询以A开头的所有数据. select * from table where id like '%A' 查询以A结尾的所有数据. select * from table where id like 'A_' 查询以A开头长度为2的数据. select * from table where id like '_A_'(或'%A%') 查询A在中间的数据. select * from table where id like '[^A]%' 查询不带A的数据.
select * from table不就可以了嗎?
或:select * from table where cast(id as varchar) like '%'
id
A001
B001
A002select * from table1 where id like 'A%'
结果:
A001
A002
select * from table1 where id like '_001'
结果:
A001
B001
crazyboyII(疯狂女孩) :既是跪求,那就给progress99兄奉上照片一张!
開開玩笑也好嘛,人其實很需要調節。
to: leeboyan(宝宝)
寶兄弟!
select * from table where id like '%A' 查询以A结尾的所有数据.
select * from table where id like 'A_' 查询以A开头长度为2的数据.
select * from table where id like '_A_'(或'%A%') 查询A在中间的数据.
select * from table where id like '[^A]%' 查询不带A的数据.