Parameter | Type |
---|---|
URL | string, anyuri |
arg1 | string, anyuri |
Returns: string
Example
query:
SELECT URL_EXTRACT_PARAMETER("http://google.com:80/search?foo=bar", "foo")
results:
url_extract_parameter |
---|
bar |
A function used to extract a given parameter from a section of a validly formatted url according to RFC 2396 (https://tools.ietf.org/html/rfc2396.html), in format [protocol:][//host[:port]][path][?query][#fragment].
Parameter | Type |
---|---|
URL | string, anyuri |
arg1 | string, anyuri |
query:
SELECT URL_EXTRACT_PARAMETER("http://google.com:80/search?foo=bar", "foo")
results:
url_extract_parameter |
---|
bar |