如何在 mysql 中更新 JSON

如何更新这样的 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
   }
]