select count(*) from AUTOPHONECALL where CALLSTATE=1 and callid<>0 and CONTENTTYPE<>'外部语音'
and (dbms_lob.instr(AUTOPHONECALL.phonelist, '026699999', 1, 1) > 0or dbms_lob.instr(AUTOPHONECALL.phonelist, '026699999', 1, 1) > 0
or dbms_lob.instr(AUTOPHONECALL.phonelist, '13902919999', 1, 1) > 0)
以上是进行了三个电话号码的模糊查询