MySQL Knowledge Base

Selecting multiple WHERE conditions on same column

SELECT id FROM table WHERE feature = ‘eyes’
INTERSECT
SELECT id FROM table WHERE feature = ‘fangs’