데이터베이스 질문과 답변

정규식 질문 2 356

by swlee [SQL Query] [2016.07.25 09:29:14]

오라클 정규식에서 숫자뒤에 특정문자가 있는것을 어떻게 찾나요?

ex) 50mg이 있다면 mg로  찾고 싶습니다.

by jkson [2016.07.25 10:02:48] 

with t as
(
select '50mg' txt from dual union all
select '50kg_50mg' from dual union all
select '50' from dual union all 
select 'mg50' from dual union all
select 'mg good' from dual union all
select '50mg50' from dual union all
select '50m' from dual union all
select 'mg' from dual union all
select '1mg' from dual union all
select '50g' from dual
)
select *  from t
where regexp_like(txt, '^[0-9]+mg$')

 

by swlee [2016.07.25 18:14:06]

감사합니다