Page 1 of 1

[SOLVED] MySQL statement not working

Posted: Tue Aug 23, 2005 3:02 pm
by ljCharlie
Why is the following sql statement not working?

Code: Select all

SELECT *
FROM boardMember
WHERE brdPosition = NULL
ORDER BY brdLstName ASC
The above generates nothing. Why is that? The brdPosition columns contains some NULL values and some don't. I want to filter all the NULL values. How do I do that?

Thanks!

Posted: Tue Aug 23, 2005 3:08 pm
by John Cartwright

Code: Select all

SELECT *
FROM boardMember
WHERE brdPosition IS NULL
ORDER BY brdLstName ASC

Posted: Tue Aug 23, 2005 3:11 pm
by ljCharlie
Perfect!!!

It works!

Many thanks to you.