查询手机号
把所有手机号里带 6666 的手机号都查出来
还要包括 13706066669 类似这种连着6 还有个6的号
排除 66666 666666 666的 都得排除..
select mobile from table_user where .......................
------解决方案--------------------
------解决方案--------------------
- SQL code
create table phoneno(pno varchar2(20));insert into phonenoselect '13766666021' from dualunionselect '13760666601' from dualunion select '13766606660' from dual;commit;select pno, substr(pno,instr(pno,'6666',1)), substr(substr(pno,instr(pno,'6666',1)),1,5), case when substr(substr(substr(pno,instr(pno,'6666',1)),1,5),1,4) = '6666' and substr(substr(substr(pno,instr(pno,'6666',1)),1,5),5,1) <> '6' then 'YES' else 'NO' end from phoneno;