字段有null ！=的出不来

mysql> select * from columns;  
+------+------+
| id   | nid  |
+------+------+
| 1    | 2    |
| 2    | NULL |
+------+------+

mysql> select * from columns where nid!=2;
Empty set (0.00 sec)