SQLite 3 · Everyday SQL
Read a value from JSON
Extract a field from a JSON text column.
SELECT json_extract(data, '$.name') FROM events;
Official SQLite 3 documentation
SQLite 3 · Everyday SQL
Extract a field from a JSON text column.
SELECT json_extract(data, '$.name') FROM events;
Official SQLite 3 documentation
Was this page helpful?