12.3.2 Comparison Functions and Operators - MySQL

IS NOT boolean_value syntax was added in MySQL 5.0.2. ... To comply with the SQL standard, IN returns NULL not only if the expression on the left hand side is  ...

dev.mysql.com