MySQL筛选手机号，使用正则匹配

#筛选130开头手机号并保存到新表中

CREATE TABLE 一三零 AS

SELECT phone

FROM fifty WHERE phone REGEXP "^[1](30)[0-9]{8}$";

#筛选158开头最后两位都小于5的手机号

CREATE TABLE 一五八五五下 AS
SELECT phone
FROM fifty WHERE phone REGEXP "^[1](58)[0-9]{6}[0-4]{1}[0-4]{1}$";