Syntax
Scalar
Arguments
Returns
- Type: STRING
- Possible values: The encoded or decoded string.
- NULL behavior: Returns NULL for NULL input.
Properties
Usage notes
- Encoding maps spaces to plus signs; decoding maps plus signs to spaces.
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Encodes a string using application/x-www-form-urlencoded rules.
url_encode(value)
| Name | Type | Required | Description |
|---|---|---|---|
| value | STRING | Yes | The string to convert. |
| Property | Value |
|---|---|
| Deterministic | Yes |
| Supports window usage | No |
| Exact result | Yes |
SELECT url_encode('a b+c') AS "value";
| value |
|---|
| a+b%2Bc |
SELECT url_encode('a/b?x=1') AS encoded;
| encoded |
|---|
| a%2Fb%3Fx%3D1 |