New versions: Dev (3.14)

JSON_EXISTS predicate

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The JSON_EXISTS predicate can be used to check whether a JSON path expression produces a value within a JSON document (see also the JSON_VALUE function)

SELECT 1
FROM dual
WHERE json_exists('{"a":1}', '$.a')
create.selectOne()
      .where(jsonExists(val(JSON.valueOf("{\"a\":1}")), "$.a"))
      .fetch();
The jOOQ Logo