database - MYSQL IN statement

Question

Im using IN to select stuff...

WHERE categories IN ("red", "blue", "green")

This selects any item in red, blue or green categories, my question is, is there a way to select an item that has to be in all three categories?

Answer 1

SELECT Item
    FROM YourTable
    WHERE categories IN ('red', 'blue', 'green')
    GROUP BY Item
    HAVING COUNT(DISTINCT categories) = 3