7,714
社区成员
发帖
与我相关
我的任务
分享
select * from [table1] where [a] like '2|*' or [a] like '*|2'
select *
from yourTable
where a = '2'
or a like '2 |*'
or a like '*|2 |*'
or a like '*|2'
select *
from yourTable
where a = '2'
or a like '2 |%'
or a like '%|2 |%'
or a like '%|2'