|
with t as(select '92_93_94_96_98' as str,8 as id from dual union all
select '92_93_94_96_98' as str,2 as id from dual union all
select '92_93_94_96_98' as str,92 as id from dual union all
select '92_93_94_96_98' as str,98 as id from dual union all
select '92_93_94_96_98' as str,96 as id from dual union all
select '92_93_94_96_98' as str,4 as id from dual union all
select '92_93_94_96_98' as str,6 as id from dual union all
select '92_93_94_96_98' as str,9 as id from dual union all
select '92_93_94_96_98' as str,94 as id from dual union all
select '92_93_94_96_98' as str,3 as id from dual union all
select '92_93_94_96_98' as str,93 as id from dual)
select * from t
where regexp_like(str,id)
数据:
STR ID
92_93_94_96_98 8
92_93_94_96_98 2
92_93_94_96_98 92
92_93_94_96_98 98
92_93_94_96_98 96
92_93_94_96_98 4
92_93_94_96_98 6
92_93_94_96_98 9
92_93_94_96_98 94
92_93_94_96_98 3
92_93_94_96_98 93
最终需求: 已下划线分隔,精确匹配
STR ID
92_93_94_96_98 92
92_93_94_96_98 98
92_93_94_96_98 96
92_93_94_96_98 94
92_93_94_96_98 93
谢谢!
|
|