URL_EXTRACT_QUERY

A function used to extract the query section from 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

Returns: string

Example

query:

SELECT URL_EXTRACT_QUERY("http://google.com:80/search?foo=bar")

siyeh/sql-crm-example-data Run query Copy code

results:

url_extract_query
foo=bar