Skip to main content
Returns NULL if the input string is a valid JSON document or NULL. Otherwise, returns an error message.

​
Syntax

​
Parameters

​
Return Type

The CHECK_JSON function returns a result of type TEXT.

​
Remarks

If you don’t care about the error message, you can also use the JSON_IS_VALID function.

​
Examples

Example The following code example validates a simple JSON string. Returns NULL because the input string is valid JSON.

Rows: 1Execution time: 5.15ms

Example The following code example validates a simple JSON string. Returns an error message because the input string is invalid JSON as it contains two JSON objects next to each other.

Rows: 1Execution time: 4.89ms