有这样的一些数据:
select 'fie_a' as col from dual
union all
select 'fie_b' as col from dual
union all
select 'fi_a' as col from dual
union all
select 'fi_b' as col from dual;
我需要从这些数据中查找fi_开头的数据,一般写法是:
select *
from (
select 'fie_a' as col from dual
union all
select 'fie_b' as col from dual
union all
select 'fi_a' as col from dual
union all
select 'fi_b' as col from dual
) t
where t.col like 'fi_%';
但这样写并不能得到我们想要的结果,那么我们需要作如下处理:
select *
from (
select 'fie_a' as col from dual
union all
select 'fie_b' as col from dual
union all
select 'fi_a' as col from dual
union all
select 'fi_b' as col from dual
) t
where t.col like 'fi\_%' escape '\';