% 任意字符
_ 任意一个字符
in (value,......) 在这里
not in (value,......) 不在这里
mysql> select 'a' not in (1,2,3,'aa'); +-------------------------+ | 'a' not in (1,2,3,'aa') | +-------------------------+ | 1 | +-------------------------+ 1 row in set, 1 warning (0.00 sec) mysql> select 'a' in (1,2,3,'aa'); +----------------------+ | 'a' in (1,2,3,'aa') | +----------------------+ | 0 | +----------------------+ 1 row in set, 1 warning (0.00 sec) mysql> select 'a' like '_'; +--------------+ | 'a' like '_' | +--------------+ | 1 | +--------------+ 1 row in set (0.00 sec) mysql> select 'a' like '_a'; +---------------+ | 'a' like '_a' | +---------------+ | 0 | +---------------+ 1 row in set (0.00 sec) mysql> select 'a' like '%a'; +---------------+ | 'a' like '%a' | +---------------+ | 1 | +---------------+ 1 row in set (0.00 sec) mysql>