Skip to main content
Unlisted page
This page is unlisted. Search engines will not index it, and only users having a direct link can access it.
Version: 3.2

url_extract_host

Description​

Extracts the host section from a URL.

Syntax​

VARCHAR url_extract_host(VARCHAR str)

Parameters​

  • str: the string to extract its host string. If str is not a string, this function will try implicit cast first.

Return value​

Returns the host string.

Examples​

mysql> select url_extract_host('httpa://starrocks.com/test/api/v1');
+-------------------------------------------------------+
| url_extract_host('httpa://starrocks.com/test/api/v1') |
+-------------------------------------------------------+
| starrocks.com                                         |
+-------------------------------------------------------+