17,140
社区成员




SQL> with t as(
2 select 1 id,'james,tom,scott,102,a' name from dual union all
3 select 3,'bbc,cnn,tvb,cctv' from dual union all
4 select 4,'beijing,shanghai,guangzhou,dalian' from dual)
5 select *
6 from t
7 where instr(name,'tvb,cctv')>0
8 or instr(name,'beijing')>0;
ID NAME
---------- ---------------------------------
3 bbc,cnn,tvb,cctv
4 beijing,shanghai,guangzhou,dalian
--instr()函数,检查字段tb_col中是否含有n_int:
select tb_col
from table_name
where instr(tb_col,n_int)>0