17,377
社区成员
发帖
与我相关
我的任务
分享
select * from tb where instr('Set3,Nov6,Aug2',meetingdate)>0
scott@YPCOST> ed
已写入 file afiedt.buf
1 with tb as(
2 select 'Aug1' meetingdate from dual union all
3 select 'Sep3' from dual union all
4 select 'Aug2' from dual union all
5 select 'Nov6' from dual union all
6 select 'Set9' from dual)
7* select * from tb where instr('Set3,Nov6,Aug2',meetingdate)>0
scott@YPCOST> /
MEET
----
Aug2
Nov6