Url

This section contains reference documentation for the url functions.

Returns the url-encoded or url-decoded string of the input string with UTF_8 encoding, formatting details see java.net.URLEncoder

Signature

encodeUrl(string)

decodeUrl(string)

Usage Examples

SELECT concat('https://www.google.com/search?q=', encodeUrl('key1=val1 key2=45% key3=#47'),'') AS encoded
FROM ignoreMe

encoded
https://www.google.com/search?q=key1%3Dval1+key2%3D45%25+key3%3D%2347

SELECT decodeUrl('https://www.google.com/search?q=key1%3Dval1+key2%3D45%25+key3%3D%2347') AS decoded
FROM ignoreMe

decoded
https://www.google.com/search?q=key1=val1 key2=45% key3=#47