题解 | 电话号码格式校验
电话号码格式校验
https://www.nowcoder.com/practice/2c2453e909c04c29a04c11e9d6b2c769
select id,
name,
phone_number
from contacts
where (phone_number like '__________' or phone_number like'___-___-____')
and
phone_number not like '0%'
and
phone_number not regexp '[a-z]'
order by id;
，感觉有些诈骗短信就这么发的