By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable (ID int Auto_increment primary key,
JSON_COLUMN Varchar(1000))
INSERT INTO mytable VALUES (NULL,'[
{
"Name":"Number",
"Id":"PhoneNumber",
"Value":"+393123456789"
},
{
"Name":"Name",
"Id":"FirstName",
"Value":"John"
},
{
"Name":"City",
"Id":"CityID",
"Value":"NYC"
}
]')
UPDATE mytable SET JSON_COLUMN = REPLACE(JSON_COLUMN,'NYC','CALI') WHERE ID = 1
Rows matched: 1 Changed: 1 Warnings: 0
SELECT * FROM mytable
| ID | JSON_COLUMN |
|---|---|
| 1 | [ { "Name":"Number", "Id":"PhoneNumber", "Value":"+393123456789" }, { "Name":"Name", "Id":"FirstName", "Value":"John" }, { "Name":"City", "Id":"CityID", "Value":"CALI" } ] |