Mega Code Archive

 

Categories / MySQL / Function

 

The IN() function can be used to test one value against a number of possible values

mysql> mysql> SELECT 'a' IN ('b','c','a'); +----------------------+ | 'a' IN ('b','c','a') | +----------------------+ |                    1 | +----------------------+ 1 row in set (0.00 sec) mysql>