I have MySQL query, which contain IN clause


select ItemID

from ItemCategory

where CategoryID in (5,6,7,8) 

group by ItemID


I need it to work like an AND across multiple rows.