SQL 正则表达式 测试

----------------------------------------------------------

select *
from test ;

**
11
11**
11aa
11aa**
aa
aa**

;

-- 包含a-z字符
select *
from test
where regexp_like(model, '[a-z]') ;


11aa
11aa**
aa
aa**
;

-- 包含a-z以外字符的
select *
from test
where regexp_like(model, '[^a-z]') ;


**
11
11**
11aa
11aa**
aa**
;

-- 只包含a-z字符的
select *
from test
where regexp_like(model, '^[a-z]+$') ;


aa
;

select *
from test
where not regexp_like(model, '[^a-z]') ;

aa

;