latest
Configuration Reference
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

1
SELECT concat('https://www.google.com/search?q=', encodeUrl('key1=val1 key2=45% key3=#47'),'') AS encoded
2
FROM ignoreMe
Copied!
encoded
https://www.google.com/search?q=key1%3Dval1+key2%3D45%25+key3%3D%2347
1
SELECT decodeUrl('https://www.google.com/search?q=key1%3Dval1+key2%3D45%25+key3%3D%2347') AS decoded
2
FROM ignoreMe
Copied!
decoded
https://www.google.com/search?q=key1=val1 key2=45% key3=#47
Last modified 1mo ago
Copy link