题解 | 找到特殊的电话号码

select distinct 电话号码 from 电话费用表
where 月份 between '201701' and '201710'
and(
substr(电话号码,-4) regexp "([0-9])\\1([0-9])\\2"
or substr(电话号码,-4) regexp "([0-9])([0-9])\\1\\2"
or substr(电话号码,-4) regexp "([0-9])\\1\\1\\1\\1"
)