SELECT 'A' IN ('A','B','C'); : IN « Comparison Functions Operators « MySQL Tutorial






  1. MySQL Tutorial
  2. Comparison Functions Operators
  3. IN
mysql>
mysql>
mysql> SELECT 'A' IN ('A','B','C');
+----------------------+
| 'A' IN ('A','B','C') |
+----------------------+
|                    1 |
+----------------------+
1 row in set (0.00 sec)

mysql>








15.7.IN
15.7.1.expr IN (value,...)
15.7.2.SELECT 'A' IN ('A','B','C');
15.7.3.You should never mix quoted and unquoted values in an IN list
15.7.4.Use IN with data in a table
15.7.5.Using IN with subquery
15.7.6.Using more than one column with a NOT IN operator