datetime query problem

[Anon]

Hello,
I have a table named "messages".

in the table i have 3 fields:
message_id (int)
sent_time (datetime)
received_time (datetime)

message_id auto-increments, and sent_time is timestamped as soon as the id is created.

i am trying to query only the messages that have not been received by using this query:

SELECT * FROM messages WHERE received='NULL'

i have 1 entry in this database where received time is null, but i can not access this record. i've tried it without quotes, and without the word null.

the query shows up if i take the "where" clause out.

so my question is, What is the best way to query a NULL value in a datetime field in mysql?

thanks for the time,
-mike

[Anon]

ps. yes that is a typo in my query: this is how it should be:

SELECT * FROM messages WHERE received_time='NULL'

[zhabala]

Usually the query for null values looks like

SELECT * FROM messages WHERE received_time IS NULL;

because NULL is a really specifici value

Zdenek

[Anon]

thank you , this works perfect =)

i really appreciate your time
-mike