URL_EXTRACT_PROTOCOL

A function used to extract the protocol 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_PROTOCOL("http://google.com/search")

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

results:

url_extract_protocol
http