SQL · JSON functions

json_valid()

Returns 1 when the text is well-formed JSON.

sqlRunnable example sql course

Syntax

json_valid(text)

Example

Open in the lab

SELECT json_valid('{"a":1}') AS valid;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.