| description |
|---|
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 |
|---|
| 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 |