MOBILEPHONE_PROVINCE

mobilephone_province(string phone_num)

  • Description: queries the province to which the mobile phone number belongs.

  • Return value type: STRING.

  • Example

    ​  select mobilephone_province('1365665****'); 
  +-----------------------------------------+
  |                    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('1365665****'); 
  +-----------------------------------------+
  |                    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('1862686****'); 
  +-----------------------------------------+
  |               China Unicom               |​