JSON_VALID

Syntax

JSON_VALID(value)

Description

Indicates whether the given value is a valid JSON document or not. Returns 1 if valid, 0 if not, and NULL if the argument is NULL.

Current

The JSON_VALID function is automatically used as a CHECK constraint for the JSON data type alias in order to ensure that a valid json document is inserted.

< 10.4.3

The JSON_VALID function is not automatically used as a CHECK constraint for the JSON data type alias.

Examples

SELECT JSON_VALID('{"id": 1, "name": "Monty"}'); +------------------------------------------+ | JSON_VALID('{"id": 1, "name": "Monty"}') | +------------------------------------------+ | 1 | +------------------------------------------+  SELECT JSON_VALID('{"id": 1, "name": "Monty", "oddfield"}'); +------------------------------------------------------+ | JSON_VALID('{"id": 1, "name": "Monty", "oddfield"}') | +------------------------------------------------------+ | 0 | +------------------------------------------------------+

See Also

• JSON video tutorial covering JSON_VALID.

_{This page is licensed: CC BY-SA / Gnu FDL}