MySQL IN clause can be used instead of using OR operator with Where clause. It can be used when where clause is applied for multiple values for same column in an SQL query.
tutorial
MySQL Tutorial : MySQL IN statement (Advanced)
The basic use of MySQL IN statement deals with one column being compared to multiple values. There are also couple of advanced uses which make interesting use cases.