我正在try 筛选出其中某个特定字段包含带有单词的特殊字符的记录.
例如:
-[ RECORD 1 ]--------------+------------------------------
id | 3151
description | Manual add from SCCM
mac_address | d4258be8d064
status | Unknown
mac_vendor | Intel Corporate
added_by | Policy Manager
added_at | 2019-02-19 14:29:21.802413+00
updated_at | 2022-10-19 10:57:15.960282+00
attributes | {"Our Device": "true"}
extras |
org_id | 1
permit_id | 1
agentless_managed_endpoint | 0
我试过了
select *
from tips_endpoints
where description = 'Manual add from SCCM'
AND attributes = '{"Our Device": "true"}';
但它失败了.
我需要能够找到属性值为{"Our Device":"True"}的记录