URL_DECODE
Decodes percent-encoded characters and replaces them with their binary value.
Syntax
URL_DECODE(<expression>)
Parameters
Parameter | Description | Supported input types |
---|---|---|
<expression> | The string to be decoded. | TEXT |
Return Type
TEXT
Example
The example below decodes the percent-encoded parameters of an URL:
SELECT URL_DECODE('https://www.firebolt.io/?example_id%3D1%26hl%3Den');
Returns: https://www.firebolt.io/?example_id=1&hl=en