17,377
社区成员
发帖
与我相关
我的任务
分享
select * FROM TB WHERE instr(','||'1,51,31,41,51'||',',','||'51'||',') > 0
select (length('1,51,31,41,51') - length(replace('1,51,31,41,51','51','')))/length('51') from dual;
select * from tb_name
where instr(',' || replace(id_list, ' ','') || ',', ',' || id || ',') > 0
--instr函数即可
select * from tb_name where instr('34,54,34,2',id)>0;