mobilephone_province(string phone_num)
-
Description: queries the province to which the mobile phone number belongs.
-
Return value type: STRING.
-
Example
select mobilephone_province('13656656940'); +-----------------------------------------+ | Zhejiang |
MOBILEPHONE_CITY
mobilephone_city(string phone_num)
-
Description: queries the city to which the mobile phone number belongs.
-
Return value type: STRING.
-
Example
select mobilephone_city('13656656940'); +-----------------------------------------+ | Hangzhou |
MOBILEPHONE_ISP
mobilephone_isp(string phone_num)
-
Description: queries the ISP to which the mobile phone number belongs.
-
Return value type: STRING.
-
Example
select mobilephone_isp('18626862020'); +-----------------------------------------+ | China Unicom |