SQL Help

When using "IN" in a select statement is there a way to make sure all items match?

So if you say:

id IN (1,2,3)

I want to get all records that match all 3, if it only matchs 2 of the 3 it wouldn't be returned but if it matched all 3 and a fourth it would return it.

I'm not even sure how to phrase this question... But maybe if someone gets the jist of what I'm trying to say they can help me figure this out...

Thanks