SELECT WHERE field IS NULL not working

[MamaLoca]

I have been monkeying with this for while now. I want to select all the records where a specific field is empty

SELECT * FROM `maps` WHERE `description` IS NULL

It's not working and I'm not sure why. I know the records are there cause I can call them with SELECT * FROM `maps`, and I know there are empty fields but try as I might I can not get this to work. No errors just a lot of empty space where the records should be displayed

Nila __________________________________________________________________
Life would be so much easier if I only had the source code.

 

[johnwm]

Are you sure the fields are NULL - or do they contain an empty string? or even just whitespace? Try:

SELECT * FROM `maps` WHERE TRIM(`description`) =''

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[MamaLoca]

That worked, thanks. I tried the empty quotes but was unaware of TRIM.

Have looked it up and will try to remember it

http://dev.mysql.com/doc/refman/5.1/en/string-functions.html

Nila __________________________________________________________________
Life would be so much easier if I only had the source code.