Phone Number Functions
This section describes phone number functions, including their syntax, parameters, and usage examples.
Function List
Function |
Description |
---|---|
Identifies the carrier of a phone number. |
|
Identifies a phone number's city. |
|
Identifies a phone number's province. |
mobile_carrier
Identifies the carrier of a phone number.
Syntax: mobile_carrier(expr)
Parameter |
Description |
Type |
Mandatory |
---|---|---|---|
expr |
Phone number. |
String |
Yes |
Return value type: string
Example: SELECT MOBILE_CARRIER('17052294531')
Type |
Query Statement |
Returned Result |
---|---|---|
Scenario |
MOBILE_CARRIER('17052294531') |
China Mobile |
mobile_city
This function identifies a phone number's city.
Syntax: mobile_city(expr)
Parameter |
Description |
Type |
Mandatory |
---|---|---|---|
expr |
Phone number. |
String |
Yes |
Return value type: string
Example: SELECT MOBILE_CITY('17052294531')
Type |
Query Statement |
Returned Result |
---|---|---|
Scenario |
MOBILE_CITY('17052294531') |
Xi'an |
mobile_province
This function identifies a phone number's province.
Syntax: mobile_province(expr)
Parameter |
Description |
Type |
Mandatory |
---|---|---|---|
expr |
Phone number. |
String |
Yes |
Return value type: string
Example: SELECT MOBILE_PROVINCE('17052294531')
Type |
Query Statement |
Returned Result |
---|---|---|
Scenario |
MOBILE_PROVINCE('17052294531') |
Shaanxi |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot