URL_EXTRACT_HOST

A function used to extract the host 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_HOST("http://google.com#foo")

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

results:

url_extract_host
google.com