MySQL Query - Not Equal to THIS and THIS

Question

I'm getting some weird results, so I need to just check myself...

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

To be clear, these are allowed:

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

THis is NOT allowed to be returned from my query:

pending = 1, complete = 0

What am I missing here...?

Answer 1

Try:

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

or

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

EDIT: I went and looked at: http://dev.mysql.com/doc/refman/4.1/en/expressions.html

Answer 2

You need to use OR, not AND. Your expression leaves out any combination where complete = 0 or pending = 1, which is too restrictive. Try the following:

SELECT *
FROM Table
WHERE complete != 0 OR pending != 1;
                    ^^ change AND to OR

Sample: http://sqlize.com/G8j6sFqo09