Match any:
Must match at least one string. In this example the product type must be either 'electronics', 'books', or 'video'.
SELECT *
FROM purchase_table
WHERE product_type LIKE ANY ('electronics', 'books', 'video');
Match all (must meet all requirements).
In this example both 'united...