求一正则表达式

[lchh0917]

请教个正则表达式sql
deal_Man_Ids 为varchar2类型字段 有以下几种情况

deal_Man_Ids
-------------
12
12,2312
94,12,2312
55,43423,12
05124,1534
... --其他略

SELECT * FROM T_WORK_CONTACT_PROCCESS P
WHERE
P.DEAL_MAN_IDS = '12' OR
P.DEAL_MAN_IDS LIKE '%,12,%' OR
P.DEAL_MAN_IDS LIKE '%,12' OR
P.DEAL_MAN_IDS LIKE '12,%'；

能用正则表达式简化where从句吗？

[tangren]

SELECT * FROM T_WORK_CONTACT_PROCCESS P
WHERE ','||P.DEAL_MAN_IDS||',' like '%,12,%';

[桃花岛黄岛主]

with t as(
         select '12' txt from dual union all
         select '12,2312' txt from dual union all
         select '94,12,2312' from dual union all
         select '05124,1534' from dual )
    select * from  t where regexp_like(txt,'^12$|,12|,12,|12,') 

-----------------------------------
12
12,2312
94,12,2312

[lchh0917]

[Quote=引用 2 楼 wang123kui 的回复:]
SQL code

with t as(
select '12' txt from dual union all
select '12,2312' txt from dual union all
select '94,12,2312' from dual union all
select '05124,1534' ……
[/Quote]
就是这个regexp_like，感激！

[lchh0917]

[Quote=引用 1 楼 tangren 的回复:]
SELECT * FROM T_WORK_CONTACT_PROCCESS P
WHERE ','||P.DEAL_MAN_IDS||',' like '%,12,%';
[/Quote]
tangren(老兵新手) 这个写法也很巧呀，谢谢！