[RESOLVED] Querying NULL

[netfrugal]

I have a simple query question about getting all records with NULL in the field.

This is what I've been trying:

SELECT * FROM tbl WHERE column = 'NULL'

But it keeps returning 0 records.
Is the query wrong? How do I select all records with NULL in the field?
If there was a zero, or another number, that would be easy, but in this case, I can't select all rows that have NULL in one column.

Also, I want to filter my results a little more than that.
There are rows with my ip address that I don't want to show up in my search results.

So, how do I SELECT *, but leave out records with my ip address from column ip_address?

thanks!

[NogDog]

You're checking for the string literal 'NULL'. I believe what you want is:

SELECT * FROM tbl WHERE column IS NULL

[NogDog]

For the 2nd question, perhaps something like:

SELECT * FROM table WHERE column IS NULL AND ip_addr != '1.2.3.4'

[netfrugal]

Excellent! That totally worked! Thanks!