日期:2014-05-17 浏览次数:20811 次
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('\')
------解决方案--------------------
select * from jgxx where jgbm like '%s\%%'escape('\')