select (case when instr (x,'a')>0 or instr (x,'b')>0 or instr (x,'c')>0 then 1 else 0 end)from r大概是这个意思。
select (case when instr(t.a,'b')>=0 or instr(t.a,'c')>=0 then 1 else 0 end) from table t
