sql 案例
SELECT
JSON_UNQUOTE(JSON_EXTRACT(remark, '$.deviceIp')) AS ip
FROM intellect_identify_camera
where JSON_UNQUOTE(JSON_EXTRACT(remark, '$.deviceIp')) ='127.0.0.1'
;
sql 案例
SELECT
JSON_UNQUOTE(JSON_EXTRACT(remark, '$.deviceIp')) AS ip
FROM intellect_identify_camera
where JSON_UNQUOTE(JSON_EXTRACT(remark, '$.deviceIp')) ='127.0.0.1'
;