Update or insert a JSON field

sql

UPDATE settings
SET config = json_set(config, '$.theme', 'dark')
WHERE user_id = 1;

Explanation

A practical way to update JSON without replacing the whole document in app code.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Update and expand JSON

Delete one path from a document.

Open In sheetsqlsame section

Turn array elements into result rows.

Open In sheetsqlsame section

Search inside per-row arrays.

Open In sheetsqlsame section

Read one property from a JSON document.

Open In sheetsql1 tag match

Read a JSON path with operator syntax.

Open In sheetsql1 tag match

Check whether a string contains valid JSON.

Open In sheetsql1 tag match