Parameter | Type |
---|---|
URL | string, anyuri |
Returns: integer
Example
query:
SELECT URL_EXTRACT_PORT("http://google.com:80/search")
results:
url_extract_port |
---|
80 |
A function used to extract the port 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 |
query:
SELECT URL_EXTRACT_PORT("http://google.com:80/search")
results:
url_extract_port |
---|
80 |