mysql版本:5.7.20(mysql 5.7及以上)
查询一层:
SELECT * FROM table WHERE JSON_EXTRACT(request_content, "$.Content") = '1'
说明:JSON_EXTRACT(列名,"$.json某个属性")
查询多层:
SELECT * FROM devices
WHERE json_extract(json_extract(json_extract(json_data,"$.lastOperation"),"$.target"),"$.name") = '西门门岗闸机01'