url_decode
url_decodeβ
descriptionβ
Converts an url to a decode string.
Syntaxβ
VARCHAR url_decode(VARCHAR url)
Parametersβ
- url: the string to decode. If url is not a string type.
exampleβ
mysql> mysql> select url_decode('https%3A%2F%2Fdoris.apache.org%2Fzh-CN%2Fdocs%2Fsql-manual%2Fsql-functions%2Fstring-functions');
+------------------------------------------------+
| url_decode('https%3A%2F%2Fdoris.apache.org%2Fzh-CN%2Fdocs%2Fsql-manual%2Fsql-functions%2Fstring-functions') |
+------------------------------------------------+
| https://doris.apache.org/zh-CN/docs/sql-manual/sql-functions/string-functions |
+------------------------------------------------+
keywordsβ
URL DECODE