JSON_VALID(…)

1. Supports the standard is json test

The json_valid function returns 1 if the argument string contains valid JSON. Otherwise it returns null if the input was null or 0 for any non-null non-JSON value.

Similar to the is json test of standard SQL json_valid allows objects to contain the same key several times.

{"a": 42,
 "a": 1}

Related

Product Documentation

• MariaDB: JSON_VALID

• MySQL: Functions That Return JSON Value Attributes: JSON_VALID

• SQLite: The json_valid() function (also a two-argument form)

Standard SQL Features

• T821, “Basic SQL/JSON query operators”

  • … Is Json [Array|Object|Scalar]: Test for Valid JSON, Distinguish between Arrays, Objects and Scalars

  • T822, “SQL/JSON: IS JSON WITH UNIQUE KEYS predicate”

• T832, “SQL/JSON path language: item method”

  • .type() item method

• T851, “SQL/JSON: optional keywords for default syntax”

Non-Standard Alternatives

• isjson() function

• safe.parse_json() function

Tutorials

• JSON in SQL:2016

Normative References

The json_valid function is not covered by the international SQL standard ISO/IEC 9075-2:2023.