JSON
Scalar
json_extract_string()
Reference: DuckDB 2.0.0
Arguments & returns
6 overloadsjson_extract_string(json, index)
Scalar
json_extract_string(json, path)
Scalar
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.
Haybarn WASM 2.0.0-rc12 · In your browser
Guide recipe · Run to view results.