假设这里有check_result的表,我们需要从里面查询检查报告json字段checkresult
这样是可以查询到数据的
SELECT ID
,
checkresult :: json -> 'name' AS check_name,
checkresult
FROM
check_result
WHERE
( checkresult :: json -> 'name' ) :: TEXT like '%德玛西亚%';
这样是不行的。难道是不等于?
SELECT ID
,
checkresult :: json -> 'name' AS check_name,
checkresult
FROM
check_result
WHERE
( checkresult :: json -> 'name' ) :: TEXT = '德玛西亚';
这样也是可以的
SELECT ID
,
checkresult :: json -> 'name' AS check_name,
checkresult
FROM
check_result
WHERE checkresult->>'name' ='德玛西亚' ;