| 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 |