PHP DB - Selecting Null columns

Author

Selecting Null columns

Pambos Nicolaou

2004-04-22, 2:31 am

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.
[color=darkred]

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

Pete M

2004-04-22, 9:32 am

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.
>
>
>
> 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

Sponsored Links