Skip to content

Query the city and ISP to which a mobile number belongs

Use the mobile_city function to query the city to which a mobile number belongs. Use the mobile_carrier function to query the ISP to which a mobile number belongs. The results are displayed in a table.

SQL
|
SELECT
  mobile_city(17600001234) as "City to which a mobile number belongs",
  mobile_carrier(17600001234) as "ISP to which a mobile number belongs"