Finds values for fieldname that match the list of values inside the parenthesis. This is equivalent to using the OR operator (such as fieldname = value1 OR fieldname = value2 OR ...). Using the IN() operator results in better overall performance.

 

 

Example:

SELECT productid FROM products WHERE productid IN(1,3,5,7,11)