URL_EXTRACT_HOST

Learn how to use the URL_EXTRACT_HOST string function in PlaidCloud Lakehouse. Extracts the host from a URL string - see syntax, examples, and output.

Extracts the host from a URL string.

Analyze Syntax

func.url_extract_host(<url>)

Analyze Examples

func.url_extract_host('https://docs.starrocks.io/path')

┌─────────────────────┐
│ 'docs.starrocks.io'  │
└─────────────────────┘

SQL Syntax

URL_EXTRACT_HOST(<url>)

SQL Examples

SELECT URL_EXTRACT_HOST('https://docs.starrocks.io/path');

┌───────────────────┐
│ docs.starrocks.io  │
└───────────────────┘