SQL · JSON functions

json_set()

Adds or replaces a value at a path.

sqlRunnable example sql course

Syntax

json_set(json, path, value)

Example

Open in the lab

SELECT json_set('{"a":1}', '$.b', 2) AS updated;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.