Determines whether a value is within a specified range, defined by a subquery, expression, or list.
expression [ NOT ] IN ( compExpression [, compExpression ... ] )
expression: the expression to evaluate.
compExpression: any valid expression which evaluates to a value which can be compared to expression.
Note: There is no theoretical limit to the number of the compExpressions which can be included with IN.
- The row or value, when the evaluation is true.
- It is not necessary for the IN comparison expressions to appear in any particular order.
SELECT cust_id, saledate, amnt FROM MYSQL.inventory.cust_sales WHERE saledate IN (DATE('2005-01-01'), DATE('2010-12-31')); VALUES '2008' IN ('2010', '2000', '2008') -- Returns true