1 of 1

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)

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

encoded

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

decoded

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

encodeUrl(string)
decodeUrl(string)

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

encoded

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

decoded