URL_DECODE
Unescapes the given URL encoded value.
This function is the inverse of URL_ENCODE
.
url_decode(value) → varchar
Unescapes the URL encoded value
. This function is the inverse of url_encode()
.
Syntax
Arguments
VALUE
VALUE
Type: string
A URL encoded value.
Returns
Type: string
The decoded VALUE
.
Examples
"SELECT url_decode('The+quick+brown+fox') = 'The quick brown fox' AND url_decode('Comment+%235') = 'Comment #5' AND url_decode('%26%24%23_line_%21123') = '&$#line!123' AND url_decode('') = '' AND url_decode('word%2Bword++word') = 'word+word word'"
Transformation job example
SQL
Query result
Last updated