insert into tmp2 select '114' from dual union all select '125' from dual union all select '133' from dual union all select '22' from dualselect id,INSTR('11,22,33',id) from tmp2 ;select id,INSTR('11,22',id) from tmp2 where id like '%11%' or id like '%22%'INSTR试试
insert into tmp2
select '114' from dual union all
select '125' from dual union all
select '133' from dual union all
select '22' from dualselect id,INSTR('11,22,33',id) from tmp2 ;select id,INSTR('11,22',id) from tmp2 where id like '%11%' or id like '%22%'INSTR试试