[RESOLVED] Is equal

[mikkex]

I have a database which have this structure:

item     category number
40718    12247    169184
40720    12201    169189
40720    12182    169190
40932    12201    169209
40932    12201    169210
40864    12201    169226
44709    12371    169246
44709    12201    169242
44709    12181    169244
44709    12248    169245
44709    12195    169248
44709    12204    169249
44709    12200    169239
44710    12177    169240
44710    12176    169241
44709    12201    169243
44709    12861    169247

How do I get the results out for which item which has, let say, category 12201 and 12182?

I tried

SELECT item FROM item_category WHERE category = 12201 AND category=12182

with no luck (zero results)

[Lars_Berg]

 SELECT item 
FROM item_category 
WHERE category = 12201 
    or category=12182 
group by item
having count(*) = 2

[mikkex]

Thanks, that did the works.