MySQL中查询与更新 json 数据

查询字段

select id, json_extract(data,'$.mediaType') as reward from table;

条件查询

select id from dialog where data->'$.mediaType' = 0;
select id from dialog where data->'$.mediaType' is null;

更新

update dialog set data = json_set(data, "$.mediaType", 0) where id = '2847';