[Resolved] Search a NULL field

[luckybob]

I have a database that keeps records of movie transactions. I use a table called history to keep track of the activity for each movie. When the movie is checked out a field is created that stores the member who checked it out, the user who authorized it and date fields for the checkout date and the check in date.

My problem is when the field is created the checkin date is set to NULL until the movie is checked in. I am doing some reports for this and I want to have a list of movies where the checkin field is NULL (meaning they are still out).

How do I search for all indates that equal NULL in the history table?

I tried:
"SELECT FROM history WHERE indate=NULL"
"SELECT FROM history WHERE indate='' "

but had no luck. Is there a specific syntax, or should I just default the field to something searchable?

All help is appreciated.

[mtimdog]

You'd want to do something like this

SELECT * FROM my_table WHERE phone IS NULL;

....from the mysql man

[luckybob]

Genius....Thanks a lot.