入门题 获取电信号码段 like 优化
select tel1 from userinfo00 where tel1 like '133%' or tel1 like '189%' or tel1 like '153%'
是否可以优化成类似于
select tel1 from userinfo00 where tel1 like '【133,189,153】%'
like
------解决方案--------------------select tel1 from userinfo00 where left(tel1,3) in (133,189,153)
------解决方案--------------------
SELECT tel1 FROM userinfo00 WHERE SUBSTRING(tel1,1,3) IN('133','189','153')