JSON_VALID() - Validating JSON Value

Q

How to verify if value is a JSON (JavaScript Object Notation) value using the JSON_VALID() function?

✍: FYIcenter.com

A

JSON_VALID(val) is a MySQL built-in function that returns 1 if the given value is a valid JSON value. For example:

SELECT JSON_VALID('hello'), JSON_VALID('"hello"');
  -- +---------------------+-----------------------+
  -- | JSON_VALID('hello') | JSON_VALID('"hello"') |
  -- +---------------------+-----------------------+
  -- |                   0 |                     1 |
  -- +---------------------+-----------------------+

SELECT JSON_VALID('123'), JSON_VALID('"123"');
  -- +-------------------+---------------------+
  -- | JSON_VALID('123') | JSON_VALID('"123"') |
  -- +-------------------+---------------------+
  -- |                 1 |                   1 |
  -- +-------------------+---------------------+

SELECT JSON_VALID('{"a": 1}'), JSON_VALID('(1,2,3)');
  -- +------------------------+-----------------------+
  -- | JSON_VALID('{"a": 1}') | JSON_VALID('(1,2,3)') |
  -- +------------------------+-----------------------+
  -- |                      1 |                     0 |
  -- +------------------------+-----------------------+

Reference information of the JSON_VALID() function:

JSON_VALID(val): int
  Returns 0 or 1 to indicate whether a value is valid JSON value.

Arguments, return value and availability:
  val: Required. The value to be verified
  int: Return value. The verification result.
  Available since MySQL 5.7.

 

JSON_VALUE() - Converting JSON Value

JSON_UNQUOTE() - Unquoting JSON String

MySQL Functions on JSON Values

⇑⇑ MySQL Function References

2023-12-17, 266🔥, 0💬