mysql获取json类型字段的某些键的值

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' 

数据表如下

查询结果