mysql5.7 json update_如何在Mysql 5.7中更新JSON数组中的特定对象

How can I update an object in an array based on a unique value in the object?

Let's say this is my json object stored in a table called objects and in a column called content

table: objects

id: 7383

content: { data:[{id: 111, active: 1 }, {id: 222, active: 1 }, {id: 333, active: 0 }] }

I can update objects if I know the position of the element in the array with

SET content = JSON_REPLACE(content,'$.data[1].active', 0)

Where id = 7383

However, if I don't know the position of the array, but I do know the value of id (for example 222) in the object, how can I update active to 0 for the object that has id: 222 ?

解决方案

Currently, it's complicated to look up numerical values with MySQL J