How to search by json cell in an array?

Question

PostgreSQL

There is a task to select all rows where the json string has an array and in the array - an element that satisfies the condition, i.e.
{"a" : [2,3,4,5]}, I need to return all rows where in row a the array has an element with value 3, for example.

Answer 1

SELECT *
FROM table_name
WHERE (column_name->'a')::jsonb @> '3'::jsonb