Purpose
You can call this function to verify 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)
Notes
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