oracle中like多个值
千次阅读
2022-04-28 14:57:57
1.查询 md003 包含 LT或C或ST的数据
select * from sys_ggbom a
where regexp_like (md003,'(LT|C|ST)')
2.查询 md003 以 HT 开头的数据
select * from sys_ggbom a
where regexp_like (md003,'^(HT)')
3.查询 md003 以 HT 结尾的数据
select * from sys_ggbom a
where regexp_like (md003,'(HT)$')