如何更新更新数据库中的json值？

Question

数据库中值json格式的，类似{"id":"123","name":"xxx","orgName":"qwe.jpg"},{"id":"124","name":"xxx","orgName":"qwe2.jpg"}
我要更新每个值只保留{"name":"xxx"}