recently, app is going to do a feature similar to giving likes by Qzone. When you go to the database, you can use the new data type json after mysql 5.7 to store the like user id, so that every time a user gives a like, you can use json_merge to add an id to the field. There"s nothing wrong with adding it. The data format is as follows:
praiseList is the id list of users who like it. However, it is dumbfounded to delete data. The official json_remove method can only be deleted according to the key of json or the subscript of the array, not directly through the values in the array. I have been perplexed by this problem for a long time. I would like to ask you humbly how to deal with it.