PDA

View Full Version : MySQL selecting null values


hairsoup
2nd January 2006, 09:44
Easy one for the techies... I need to select rows from a table where the value of a field is null.

Thanks.

Coding Monkey
2nd January 2006, 09:52
"SELECT id, name_stuff, other_stuff FROM 'tablename' WHERE name_stuff IS NULL"

hairsoup
2nd January 2006, 10:36
thanks