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 = JSON_REPLACE(JSON_COLUMN,'$[2].Value','CALI') WHERE ID = 1
Rows matched: 1 Changed: 1 Warnings: 0
SELECT JSON_EXTRACT(JSON_COLUMN,'$[2].Value') FROM mytable
| JSON_EXTRACT(JSON_COLUMN,'$[2].Value') |
|---|
| "CALI" |