mysql in/no in/like

% 任意字符

_ 任意一个字符

in (value,......) 在这里

not in (value,......) 不在这里

 

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

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>