url_decode

description

Converts an url to a decode string.

Syntax

1. VARCHAR url_decode(VARCHAR url)

Parameters

• url: the string to decode. If url is not a string type.

example

1. mysql> mysql> select url_decode('https%3A%2F%2Fdoris.apache.org%2Fzh-CN%2Fdocs%2Fsql-manual%2Fsql-functions%2Fstring-functions');
2. +------------------------------------------------+
3. | url_decode('https%3A%2F%2Fdoris.apache.org%2Fzh-CN%2Fdocs%2Fsql-manual%2Fsql-functions%2Fstring-functions') |
4. +------------------------------------------------+
5. | https://doris.apache.org/zh-CN/docs/sql-manual/sql-functions/string-functions                               |
6. +------------------------------------------------+

keywords

1. URL DECODE