select query where field is null question

[will35010]

Lets say I have a table with two columns: name and id. I want to know how to run a select query like so:

 

SELECT name FROM people WHERE id = null;

 

I only want to return results where the id column is null. Thanks!

[akitchin]

have you tried that query? it looks like it should work.

[will35010]

have you tried that query? it looks like it should work.

 

I did and it didn't. 

[will35010]

Just found it on google. Thanks!

 

SELECT name FROM people WHERE id IS NULL;