JSON Scalar

json_exists()

Reference: DuckDB 2.0.0

Arguments & returns

4 overloads

json_exists(json, path)

Scalar
Overload link jsonpath Returns
#01 JSONVARCHAR BOOLEAN
#02 JSONVARCHAR[] BOOLEAN[]
#03 VARCHARVARCHAR BOOLEAN
#04 VARCHARVARCHAR[] BOOLEAN[]

In other engines

PostgreSQLjsonb_exists()

SELECT JSONB_EXISTS('{"a": [1,2,3]}', 'a')
In DuckDB
SELECT JSON_EXISTS('{"a": [1,2,3]}', '$.a')

SQLGlot example โ†—