题解 | 电话号码格式校验
电话号码格式校验
https://www.nowcoder.com/practice/2c2453e909c04c29a04c11e9d6b2c769
select id,
name,
phone_number
From contacts
where (length(phone_number)=10 and left(phone_number,1)!=0)
or (length(replace (phone_number,'-',''))=10
and(left(replace (phone_number,'-',''),1)!=0) and phone_number regexp'^(\\d{3}-\\d{3}-\\d{4})$')
order by id;
查看9道真题和解析