Home:ALL Converter>Update JSON field in MYSQL

Update JSON field in MYSQL

Ask Time:2020-04-07T15:33:07         Author:sn n

Json Formatter

I need to update mysql field with updated JSON value.

$sampleJSON = {
   "key1":"value1",
   "key2":{
       "key3":"value3"
}

I would like to replace the existing JSON object present in the database column with the newer one. How is this possible using MYSQL 8.0

}

Author:sn n,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/61074906/update-json-field-in-mysql
yy