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.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel