mysql 字段json数据里统计某个属性值的和
SELECT * FROM t_json_sum;
//查询单属性值
SELECT JSON_EXTRACT(json_data, ‘$.price’) as price FROM t_json_sum;
// 求和
SELECT sum(JSON_EXTRACT(json_data, ‘$.price’)) as total_sum FROM t_json_sum;
// json 条件 条件值注意数据类型
SELECT sum(JSON_EXTRACT(json_data, ‘$.price’)) as total_sum FROM t_json_sum where json_data->’$.price’=2;
关于 LearnKu
粤公网安备 44030502004330号