Postgresql JSON column check key exists

Question

I have wrote query like this to check json column has key

SELECT *
FROM "details" 
where ("data"->'country'->'state'->>'city') is not null;

but i need to write query which will select row if "data" contains "city"

json structure of data is not consistent.

user_4992248 · Answer

You can use ?:

SELECT *
FROM "details" 
WHERE data->'country'->'state' ? 'city';

user_8720599 · Answer

You can convert your json to text and search for the key with LIKE

SELECT *
FROM "details"
WHERE "data"::text LIKE '%"city":%'