postgresql的json类型字段的模糊查询
select properties
from geo_collection
where properties::text like '%思源%';
select properties::text as p
from geo_collection
where properties::text like '%思源%';
select "public"."geo_collection".*
from "public"."geo_collection"
where cast("public"."geo_collection"."properties" as varchar) like '%发展%';