mysql> select * from b where substr(mobile,0,3) in (133,153,177,180,181,189,199);
存在的问题:substr 不能走索引
where mobile like "133%" or mobile like "153" or xxx;
还是存在的问题:手机号 3 位数开头的太普遍了
解决:
mobile > 13300000000 and mobile <13400000000
133,153,177,180,181,189,199
这些设置一个值 select * from b where mobile_type=xxx;