Mysql Command Not Working The Way I Had Hoped!

[njdubois]

Using phpMyadmin, the mysql tool godaddy provides:

 

I have a table named users with these fields:

id, name, password, contact_id

 

there is a bunch of rows where the contact_id=NULL

 

I only want to view those:

SELECT * FROM users WHERE contact_id=NULL

 

but it returns 0 results?

 

SELECT * FROM users WHERE contact_id="NULL"

SELECT * FROM users WHERE contact_id=""

 

return the same, nothing.

 

What can I post to better help you diagnose my problem?

 

Thanks for your time!

Nick

[Christian F.]

"field IS NULL" is the proper syntax when checking for NULL in MySQL.

Edited October 26, 2012 by Christian F.

[Jessica]

"NULL" is a string. 

Try contact_id IS NULL

If that doesn't work, post your table structure, and some screenshots of the actual rows. 

 

 

[njdubois]

IS NULL is exactly what I needed!

 

Thank you so very much!!!

 

Nick