Purpose
JSON_VALID() verifies whether an input value is a valid JSON value. If the input value is a valid JSON value, 1 is returned. Otherwise, 0 is returned.
Syntax
JSON_VALID(val)
Description
val specifies the input value. If the argument is NULL, NULL is returned.
Examples
obclient> SELECT JSON_VALID('{"a": 1}');
+------------------------+
| JSON_VALID('{"a": 1}') |
+------------------------+
| 1 |
+------------------------+
1 row in set
obclient> SELECT JSON_VALID('oceanbase'), JSON_VALID('"oceanbase"');
+-------------------------+---------------------------+
| JSON_VALID('oceanbase') | JSON_VALID('"oceanbase"') |
+-------------------------+---------------------------+
| 0 | 1 |
+-------------------------+---------------------------+
1 row in set