1.查询 XX包含 LT或C或ST的数据
select * from sys_ggbom a
where regexp_like (XX,'(A|C|DT)')
2.查询 XX以 HT 开头的数据
select * from sys_ggbom a
where regexp_like (XX,'^(gg)')
3.查询 XX以 HT 结尾的数据
select * from sys_ggbom a
where regexp_like (XX,'(DF)$')
1.查询 XX包含 LT或C或ST的数据
select * from sys_ggbom a
where regexp_like (XX,'(A|C|DT)')
2.查询 XX以 HT 开头的数据
select * from sys_ggbom a
where regexp_like (XX,'^(gg)')
3.查询 XX以 HT 结尾的数据
select * from sys_ggbom a
where regexp_like (XX,'(DF)$')