入门题 获取电信号码段 like 优化select tel1 fromuserinfo00 where tel1 like 133% ortel1 like 189%
入门题 获取电信号码段 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')