modify the property value of JSON string stored in the Table Column

Question

I have JSON string stored in my database column. I have to update that value in JSON string.

Here Is my table.

I want to update the state value inside it.

Example:

Name1 has State value KA so I want to update it to GJ.

What I have Tried So far?

UPDATE Customer
SET Detail = JSON_MODIFY(Detail , '$.Address.State', 'KA')
WHERE Name = 'name1';

Also Tried JSON_REPLACE is also not working.

But it shows the error:

FUNCTION Customer.JSON_MODIFY does not exist

Note: I know one workaround to do this but I didn't Want to fetch that string and update it completely. I want to update the particular detail in string.

I have also created the SQL Fiddle.

I am doing this on localhost. Below are the localhost detail.

Database server     
Server: localhost (localhost via TCP/IP)
Software: MySQL
MySQL Version :5.5.24

phpMyAdmin
Version information: 3.5.1, latest stable version: 4.7.3

Answer 1

12.16 JSON Functions

...

Unless otherwise indicated, the JSON functions were added in MySQL 5.7.8.

...

Try:

UPDATE `Customer`
SET `Detail` = JSON_REPLACE(`Detail`, '$.Address.State', 'GJ')
WHERE `Name` = 'name1';

See db-fiddle.