For an extremely large list of names (hundreds), you could also create a temporary table to JOIN against. There's often a length limit for SQL queries, and creating a giant IN list would bump up against that.

If you've just got a few (around 100 or less), using IN or OR should work fine.