URL_DECODE

Reference material for URL_DECODE function

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');

url_decode text
https://www.firebolt.io/?example_id=1&hl=en

Rows: 1Execution time: 6.38ms

Related

• URL_ENCODE