NYCPHP Meetup

[Michael Southwell]

John Campbell wrote:
> In sql, every comparison to NULL, yields another NULL.
> That is why 'SELECT * WHERE foo = NULL' doesn't do what you might
> expect.  In fact that query is guaranteed to always return zero rows.

which is why the correct syntax for such a select would have to be 
'SELECT * [FROM table] WHERE foo IS NULL' rather than '= NULL'


-- 
=================
Michael Southwell
Vice President, Education
NYPHP TRAINING:  http://nyphp.com/Training/Indepth