Re: Selecting Null columns

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 SELECT * FROM questions WHERE answer IS  NULL
 SELECT * FROM questions WHERE answer IS NOT NULL


Pambos Nicolaou wrote:
Hi everyone

I am a new user of this mail list and I hope that it will be helpful.

I am trying to show the content of a MySQL table(raw) where the content of a column is NOT NULL. I used the commands below but the result shows the content of the whole table for the first case and nothing in the second case.

 SELECT * FROM questions WHERE answer IS NOT NULL ;
 SELECT * FROM questions WHERE answer <> NULL ;


Thanks in advance

Nicolaou Pambos

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux