mysql不包含(not in)如何使用

expr NOT IN ( value1, value2, value3 ... valueN )

mysql> SELECT 2 NOT IN (1,3,5,'thks'),'thks' NOT IN (1,3,5, 'thks');

+-------------------------+-------------------------------+

| 2 NOT IN (1,3,5,'thks') | 'thks' NOT IN (1,3,5, 'thks') |

+-------------------------+-------------------------------+

|                       1 |                             0 |

+-------------------------+-------------------------------+

1 row in set, 2 warnings (0.00 sec)