Skip to main content
Get StartedConsole GuideWork With DataRelease NotesReference
Resources
VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping

DOMAIN_WITHOUT_WWW

Description​

Extract the domain name without the prefix www in the string URL

Syntax​

DOMAIN_WITHOUT_WWW ( <url> )

Parameters​

ParameterDescription
<url>Need to extract the URL without the www domain name

Return value​

Parameter <url> Domain name without the prefix www

SELECT DOMAIN_WITHOUT_WWW("https://www.apache.org/docs/gettingStarted/what-is-apache-doris")
+---------------------------------------------------------------------------------------+
| domain_without_www('https://www.apache.org/docs/gettingStarted/what-is-apache-doris') |
+---------------------------------------------------------------------------------------+
| apache.org                                                                            |
+---------------------------------------------------------------------------------------+