JSON Scalar

json_extract_string()

Reference: DuckDB 2.0.0

Arguments & returns

6 overloads

json_extract_string(json, index)

Scalar
Overload link jsonindex Returns
#01 JSONBIGINT VARCHAR
#02 VARCHARBIGINT VARCHAR

json_extract_string(json, path)

Scalar
Overload link jsonpath Returns
#03 JSONVARCHAR VARCHAR
#04 JSONVARCHAR[] VARCHAR[]
#05 VARCHARVARCHAR VARCHAR
#06 VARCHARVARCHAR[] VARCHAR[]

In a query

Find the value inside the document.

Extract a JSON field directly as text, ready to use in the rest of your query.

Find the value inside the document.
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Guide recipe · Run to view results.