题解 | 电话号码格式校验

select 
    *
from 
    contacts
where 
    (phone_number rlike '^\\d{10}$' and phone_number not rlike '^0')
or
    (phone_number rlike '^\\d{3}\\-\\d{3}\\-\\d{4}$' and phone_number not rlike '^0')