Help Center/Log Tank Service/User Guide/Log Search and Analysis (Pipe Character)/SQL Functions/URL Functions
Updated on 2025-08-14 GMT+08:00
View PDF

URL Functions

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

Function List

Table 1 URL functions

Function

Description

url_encode

Encodes a URL.

url_decode

Decodes a URL.

url_extract_fragment

Extracts the fragment information from a URL.

url_extract_host

Extracts the host information from a URL.

url_extract_parameter

Extracts the parameter information from a URL.

url_extract_path

Extracts the path information from a URL.

url_extract_port

Extracts the port information from a URL.

url_extract_protocol

Extracts the protocol information from a URL.

url_extract_query

Extracts the query information from a URL.

url_encode

This function encodes a URL.

Syntax: url_encode(expr)

Table 2 Parameter description

Parameter

Description

Type

Mandatory

expr

URL string.

String

Yes

Return value type: string

Example: SELECT URL_ENCODE('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

Table 3 Query and analysis results

Type

Query Statement

Returned Result

Scenario

URL_ENCODE('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

http%3A%2F%2Fusername%3Apassword%40host%3A8080%2Findex%3FparameterName%3DparameterValue%23fragment

url_decode

This function decodes a URL.

Syntax: url_decode(expr)

Table 4 Parameter description

Parameter

Description

Type

Mandatory

expr

URL string.

String

Yes

Return value type: string

Example: SELECT URL_DECODE('http%3A%2F%2Fusername%3Apassword%40host%3A8080%2Findex%3FparameterName%3DparameterValue%23fragment')

Table 5 Query and analysis results

Type

Query Statement

Returned Result

Scenario

URL_DECODE('http%3A%2F%2Fusername%3Apassword%40host%3A8080%2Findex%3FparameterName%3DparameterValue%23fragment')

http://username:password@host:8080/index?parameterName=parameterValue#fragment

url_extract_fragment

This function extracts the fragment information from a URL.

Syntax: url_extract_fragment(expr)

Table 6 Parameter description

Parameter

Description

Type

Mandatory

expr

URL string.

String

Yes

Return value type: string

Example: SELECT URL_EXTRACT_FRAGMENT('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

Table 7 Query and analysis results

Type

Query Statement

Returned Result

Scenario

URL_EXTRACT_FRAGMENT('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

fragment

url_extract_host

This function extracts the host information from a URL.

Syntax: url_extract_host(expr)

Table 8 Parameter description

Parameter

Description

Type

Mandatory

expr

URL string.

String

Yes

Return value type: string

Example: SELECT URL_EXTRACT_HOST('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

Table 9 Query and analysis results

Type

Query Statement

Returned Result

Scenario

URL_EXTRACT_HOST('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

host

url_extract_parameter

This function extracts the parameter information from a URL.

Syntax: url_extract_parameter(expr, paramName)

Table 10 Parameter description

Parameter

Description

Type

Mandatory

expr

URL string.

String

Yes

paramName

Parameter

String

Yes

Return value type: string

Example: SELECT URL_EXTRACT_PARAMETER('http://username:password@host:8080/index?parameterName=parameterValue#fragment', 'parameterName')

Table 11 Query and analysis results

Type

Query Statement

Returned Result

Scenario

URL_EXTRACT_PARAMETER('http://username:password@host:8080/index?parameterName=parameterValue#fragment', 'parameterName')

parameterValue

url_extract_path

This function extracts the path information from a URL.

Syntax: url_extract_path(expr)

Table 12 Parameter description

Parameter

Description

Type

Mandatory

expr

URL string.

String

Yes

Return value type:

String

Example: SELECT URL_EXTRACT_PATH('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

Table 13 Query and analysis results

Type

Query Statement

Returned Result

Scenario

URL_EXTRACT_PATH('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

/index

url_extract_port

This function extracts the port information from a URL.

Syntax: url_extract_port(expr)

Table 14 Parameter description

Parameter

Description

Type

Mandatory

expr

URL string.

String

Yes

Return value type: string

Example: SELECT URL_EXTRACT_PORT('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

Table 15 Query and analysis results

Type

Query Statement

Returned Result

Scenario

URL_EXTRACT_PORT('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

8080

url_extract_protocol

This function extracts the protocol information from a URL.

Syntax: url_extract_protocol(expr)

Table 16 Parameter description

Parameter

Description

Type

Mandatory

expr

URL string.

String

Yes

Return value type: string

Example: SELECT URL_EXTRACT_PROTOCOL('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

Table 17 Query and analysis results

Type

Query Statement

Returned Result

Scenario

URL_EXTRACT_PROTOCOL('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

http

url_extract_query

This function extracts the query information from a URL.

Syntax: url_extract_query(expr)

Table 18 Parameter description

Parameter

Description

Type

Mandatory

expr

URL string.

String

Yes

Return value type: string

Example: SELECT URL_EXTRACT_QUERY('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

Table 19 Query and analysis results

Type

Query Statement

Returned Result

Scenario

URL_EXTRACT_QUERY('http://username:password@host:8080/index?parameterName=parameterValue#fragment')

parameterName=parameterValue

Parent topic:SQL Functions