1234567891011121314151617181920212223242526272829 |
- /* syntax version 1 */
- SELECT
- value,
- Url::Parse(value) AS parse,
- Url::GetSignificantDomain(value) AS significant_domain,
- Url::GetSignificantDomain(value, AsList("tl")) AS tl_is_significant,
- Url::GetTLD(value) AS tld,
- Url::PunycodeToHostName(value) AS punycode,
- Url::Encode(value) AS encode,
- Url::Decode(value) AS decode,
- Url::GetCGIParam(value, "foo") AS param,
- Url::CutQueryStringAndFragment(value) AS cut_qs_and_fragment,
- Url::CutWWW(Url::GetHost(value)) AS cut_www,
- Url::CutWWW2(Url::GetHost(value)) AS cut_www2,
- Url::GetHost(value) as host,
- Url::GetHostPort(value) as host_port,
- Url::GetSchemeHost(value) AS scheme_host,
- Url::GetSchemeHostPort(value) AS scheme_host_port,
- Url::CutScheme(value) AS cut_scheme,
- Url::GetTail(value) AS tail,
- Url::GetPath(value) AS path,
- Url::GetFragment(value) AS fragment,
- Url::GetPort(value) AS port,
- Url::GetDomain(value, 0) as domain0,
- Url::GetDomain(value, 1) as domain1,
- Url::GetDomain(value, 3) as domain3,
- Url::GetDomainLevel(value) as domain_level,
- Url::Normalize(value) as norm
- FROM Input;
|