JSON_PARSE
All functions > JSON > JSON_PARSE
Returns the given string as a JSON expression.
Syntax
JSON_PARSE(expr)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
expr | VARCHAR | Yes | The JSON string to parse |
Returns
A JSON value parsed from the string
Notes
- Parses JSON string into JSON type
- Accepts valid JSON format strings
- Supports objects, arrays, and primitives
- Returns NULL if the string is not valid JSON
- Inverse of JSON_FORMAT
- Useful for converting stored JSON strings to queryable JSON
- Validates JSON syntax during parsing
- Use JSON_EXTRACT after parsing to access nested values