查询一层:
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'