Decodes percent-encoded characters and replaces them with their binary value.

​
Syntax

URL_DECODE(<expression>)

​
Parameters

ParameterDescriptionSupported 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