url_decode

description

将URL转换为解码字符串。

Syntax

1. VARCHAR url_decode(VARCHAR url)

Parameters

• url: 待解码的url。

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