drop table cs_thz_1 ;

create table cs_thz_1(   nid number(10)  ,sname varchar2(100)  ,remark varchar2(200)    ) ;

truncate table cs_thz_1;

insert into cs_thz_1(nid,sname,remark)

select 1 nid,‘小汽车‘ sname,‘A‘ remark from dual union all

select 2 nid,‘摩托‘ sname,‘MNP‘ remark from dual union all

select 3 nid,‘自行车‘ sname,‘BD‘ remark from dual union all

select 4 nid,‘拖拉机‘ sname,‘MND‘ remark from dual union all

select 5 nid,‘卡车‘ sname,‘EF‘ remark from dual union all

select 6 nid,‘起重机‘ sname,‘PX‘ remark from dual commit;

---以A或B开头

select * from cs_thz_1 where regexp_like(remark,‘^[AB]‘) ;

---以A或C结尾

select * from cs_thz_1 where regexp_like(remark,‘[CA]$‘) ;

---含A或N的字符

select * from cs_thz_1 where regexp_like(remark,‘[AN]‘) ;

---含P或E或B的字符-----这个还没解决

select t.*,case when regexp_like(remark,‘[PEB]‘) then 1 else 0 end is_del from cs_thz_1 t ;

select t.*,‘[P,E,B]‘) then 1 else 0 end is_del from cs_thz_1 t ;

select t.*,‘[PE|E|B]‘) then 1 else 0 end is_del from cs_thz_1 t ;

select t.*,‘[(PE)|E|B]‘) then 1 else 0 end is_del from cs_thz_1 t ;