Phone Number Functions

This section describes phone number functions, including their syntax, parameters, and usage examples.

**Table 1** Phone number functions
Function	Description
mobile_carrier	Identifies the carrier of a phone number.
mobile_city	Identifies a phone number's city.
mobile_province	Identifies a phone number's province.

Identifies the carrier of a phone number.

Syntax: mobile_carrier(expr)

**Table 2** Parameter description
Parameter	Description	Type	Mandatory
expr	Phone number.	String	Yes

Return value type: string

Example: SELECT MOBILE_CARRIER('17052294531')

**Table 3** Query and analysis results
Type	Query Statement	Returned Result
Scenario	MOBILE_CARRIER('17052294531')	China Mobile

This function identifies a phone number's city.

Syntax: mobile_city(expr)

**Table 4** Parameter description
Parameter	Description	Type	Mandatory
expr	Phone number.	String	Yes

Return value type: string

Example: SELECT MOBILE_CITY('17052294531')

**Table 5** Query and analysis results
Type	Query Statement	Returned Result
Scenario	MOBILE_CITY('17052294531')	Xi'an

This function identifies a phone number's province.

Syntax: mobile_province(expr)

**Table 6** Parameter description
Parameter	Description	Type	Mandatory
expr	Phone number.	String	Yes

Return value type: string

Example: SELECT MOBILE_PROVINCE('17052294531')

**Table 7** Query and analysis results
Type	Query Statement	Returned Result
Scenario	MOBILE_PROVINCE('17052294531')	Shaanxi

Parent topic: SQL Functions

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.