데이터베이스 질문과 답변
오라클 정규식에서 숫자뒤에 특정문자가 있는것을 어떻게 찾나요?
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]
감사합니다
) 버튼을 클릭하여 작성 하시면 됩니다.