如何更新这样的 JSON 字段。具体来说，您需要更新数组属性中的所有内容food -> name，并在name更新数组中的数组属性language ee中et。
版本MySQL 5.7
您不需要完全为我做这件事，只需将我引向正确的道路即可。至少看看怎么做。
手没有统治的欲望。
田间info商店JSON
[
{
"food":{
"id":12,
"category_id":17,
"image":"uploads\/images\/menu_-FueLMDpu.jpg",
"price":23,
"price_discount":1,
"start_discount":null,
"end_discount":null,
"created_at":null,
"updated_at":null,
"deleted_at":null,
"name":[
{
"id":461,
"field":"name",
"language":"ru",
"value":"\u0431\u043b\u044e\u0434\u043e1"
},
{
"id":1116,
"field":"name",
"language":"ru",
"value":"234234"
},
{
"id":1117,
"field":"name",
"language":"en",
"value":""
},
{
"id":1118,
"field":"name",
"language":"ee",
"value":""
}
],
"description":[
{
"id":462,
"field":"description",
"language":"ru",
"value":"\u043e\u043f\u0438\u0441\u0430\u043d\u0438\u0435"
},
{
"id":1119,
"field":"description",
"language":"ru",
"value":"44"
},
{
"id":1120,
"field":"description",
"language":"en",
"value":""
},
{
"id":1121,
"field":"description",
"language":"ee",
"value":""
}
]
},
"quantity":1,
"sum":1
}
]
而是
<table_name>把表的名称。