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 '%发展%';