PostgreSQL Array: The ANY and Contains trick - Postgres OnLine Journal

PHOTO EMBED

Thu Nov 18 2021 16:37:05 GMT+0000 (Coordinated Universal Time)

Saved by @mvieira

SELECT product_name, price
    FROM products 
    WHERE 
        product_name = ANY('{apple,cherry apple,avocado}'::text[]);
content_copyCOPY

https://www.postgresonline.com/journal/archives/228-PostgreSQL-Array-The-ANY-and-Contains-trick.html