SELECT * FROM [Table] WHERE [Column]=Nul

Anon

SELECT * FROM [Table] WHERE [Column]=Null

How I can do the equivalent of the above statement in SQL? I can do:

SELECT * FROM [Table] WHERE [Column]="Value"

which returns the correct rows, but

SELECT FROM [Table] WHERE [Column]=""
.. OR ..
SELECT FROM [Table] WHERE [Column]=Null

both return nothing, even though I know some of the rows in the table contain Null in the appropriate column.

Any pointers or suggestions would be really apreciated.

Yours,

James

[deleted]

Manuals are fun, try reading some.

SELECT * FROM table WHERE column IS NULL

Anon

Thanks but I've already RTFM 🙁.

As it happens my first instinct was to try "WHERE [Column] IS NULL", but it returned no rows either, so I started to experiement with other options.

I am starting to think that maybe the data isn't really NULL, but somehow it's being stored as something else (i.e. 0, "", etc), though those also return no results.

It's strange because if I execute the IS statement directly through MySQL then it returns the rows, but not via PHP. 😕

Or do you have some magical manual that explains all this?

Thanks for responding anyway,

Yours,

James

Anon

Oops, I meant "it's being returned as something else" not "it's being stored as something else" in my reply above.

xanadu

i had success when i tried the statement in the form...

SELECT * from table where column='';

Note the use of single quotes. maybe that is preventing yours from working.

xan

Anon

Thanks Xan and Vincent. I still haven't solved my problem, though I have discovered it was only a problem on my machine. "WHERE [Column] IS NULL" works as expected on another machine.

The only immediately obvious difference between the machines is that they each have a different local database, so I am guessing that the values in the database on my PDC are not NULL for some reason. I'll recreate the DB on my machine later on and pray that fixes things.

Yours,

James

[deleted]

Which database type are you using?