#筛选130开头手机号并保存到新表中
CREATE TABLE 一三零 AS
SELECT phoneFROM 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}$";
#筛选130开头手机号并保存到新表中
CREATE TABLE 一三零 AS
SELECT phoneFROM 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}$";