MYSQL IN statement

mysql database

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

mysql database

SELECT Item    FROM YourTable    WHERE categories ALL ('red', 'blue', 'green')

CodeHunter