Returns 1 if expr is equal to any of the values in the IN list, else returns 0. | |
If all values are constants, they are evaluated according to the type of expr and sorted. | |
IN returns NULL if the expression on the left hand side is NULL. | |
IN returns NULL if no match is found in the list and one of the expressions in the list is NULL. | |
expr NOT IN (value,...) is the same as NOT (expr IN (value,...)). | |
|