SQLite 3 reference · JSON Functions

SQLite JSON_REPLACE() Function

Return JSON with values replaced at paths that already exist. Missing paths are not created.

SQLite 3 Since 3.9.0

Create a free account to save this page, take notes and track your progress. Sign in

Syntax

json_replace(json, path, value, ...)

Parameter	Description
`json`	JSON text (or JSONB).
`path`	A path such as `'$.name'`, `'$.items[0]'` or `'$.items[#-1]'` (last element).
`value`	The replacement.

The modified JSON text.

Replace only existing keysTry it yourself

SELECT json_replace('{"name":"Ada"}', '$.name', 'Grace', '$.city', 'London') AS result;

Output

result
{"name":"Grace"}

Update a valueTry it yourself

SELECT json_replace('{"stock":5}', '$.stock', 0) AS sold_out;

Output

sold_out
{"stock":0}

Version	Change
SQLite 3.9.0	Added
SQLite 3.38.0	Built in by default; earlier versions needed the JSON1 extension.

JSON_SET() · Return JSON with values set at paths, creating or overwriting them. json_insert() and json_replace() are stricter.
JSON_INSERT() · Return JSON with values added at paths that don't exist yet. Existing values are left unchanged.
SQL String Functions · tutorial