mysql 对json 数据进行查询

数据库字段为   `car_info_list` json DEFAULT NULL COMMENT '车辆信息',

SELECT
id,
event_car_plate->>'$[0]' as car_plate,
car_info_list,
car_info_list->'$[0].carPlate' as info_car_plate,
car_info_list->'$[0].speed' as speed,
car_info_list->'$[0].vehicleType' as vehicle_type,
car_info_list->'$[0].isDangerous' as is_dangerous
FROM qxsd_event_detail;

 

 

修改json的数据

UPDATE qxsd_event_detail
SET car_info_list = JSON_SET(car_info_list, '$[0].vehicleType', 0)
WHERE event_type = 20;