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