17,377
社区成员
发帖
与我相关
我的任务
分享
with t as
(
select '123%_323' a from dual
union all
select '1231%%%' a from dual
union all
select '12312312' from dual
)
select t.*
from t
where t.a like '%\_%' escape('\')
or t.a like '%\%%' escape('\')