JSON_PARSE

All functions > JSON > JSON_PARSE

Returns the given string as a JSON expression.

Syntax

JSON_PARSE(expr)
sql

Arguments

ParameterTypeRequiredDescription
exprVARCHARYesThe 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

Examples

Suggest changes to this page
Last update at: 2025/10/13 10:23:46