mysql获取json字段的某些key值
SELECT EquipId,CreateTime,
JSON_UNQUOTE ( EquipData -> '$.m1' ) as M1,
JSON_UNQUOTE ( EquipData -> '$.m2' ) as M2,
JSON_UNQUOTE ( EquipData -> '$.m3' ) as M3,
JSON_UNQUOTE ( EquipData -> '$.m4' ) as M4,
JSON_UNQUOTE ( EquipData -> '$.m5' ) as M5,
JSON_UNQUOTE ( EquipData -> '$.m6' ) as M6,
JSON_UNQUOTE ( EquipData -> '$.m7' ) as M7,
JSON_UNQUOTE ( EquipData -> '$.m8' ) as M8,
JSON_UNQUOTE ( EquipData -> '$.m9' ) as M9,
JSON_UNQUOTE ( EquipData -> '$.m10' ) as M10,
JSON_UNQUOTE ( EquipData -> '$.m11' ) as M11
FROM
seqm_carbon_main_mon
WHERE JSON_EXTRACT ( EquipData, "$.m1" ) = '19.0'
数据表如下
查询结果