[psql - search value in array ]Postgres: check if array field contains value? #psql

psql-seach-value-in-array.sql

-- check if array contains a value or multiple values
-- answer copied from https://stackoverflow.com/a/54069718

-- search for single value in array
SELECT * FROM mytable WHERE 'Book' = ANY(pub_types);

-- search an array that contains multiple values **together**
SELECT * FROM mytable WHERE pub_types @> '{"Journal", "Book"}';

--search an array that contains **one of** some values.
SELECT * FROM mytable WHERE pub_types && '{"Journal", "Book"}';