MySQL 查询 - 不等于 THIS 和 THIS

Question

我得到了一些奇怪的结果，所以我需要检查一下自己......

SELECT *
FROM table
WHERE complete != 0
AND pending != 1

明确地说，这些是允许的:

pending = 0, complete = 0
pending = 1, complete = 1
pending = 0, complete = 1

这不允许从我的查询中返回:

pending = 1, complete = 0

我在这里错过了什么......？

Answer 1

试试:

SELECT *
FROM table
WHERE NOT (complete = 0
AND pending = 1)

或

SELECT *
FROM table
WHERE !(complete = 0
AND pending = 1)

编辑:我去看看: http://dev.mysql.com/doc/refman/4.1/en/expressions.html