problm with != in query 1

[electricphp]

Why does this return results:

SELECT * FROM messages WHERE receiver_del = 'yes'

but this doesn't

SELECT * FROM messages WHERE receiver_del != 'yes'

There should be one result returned. there is one record that has the value in receiver_del set as yes.

The rest of the records have that field as null. maybe that has something to do with it?

 

[smays]

Try using "<>".

SELECT * FROM messages WHERE receiver_del <> 'yes'

 

[jaxtell]

I'm not sure about MySQL, but some databases treat null differently. how about

SELECT * FROM messages WHERE ifnull(receiver_del,'no') != 'yes'

or

SELECT * FROM messages WHERE receiver_del IS NULL

-----------------------------------------
I cannot be bought. Find leasing information at

http://www.joshaxtell.com/

 

[electricphp]

yes, this did it:

SELECT * FROM messages WHERE ifnull(receiver_del,'no') != 'yes'

seems like an awful lot of code for such a simple task