List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 21 2000 5:08pm
Subject:Re: select only not null columns.
View as plain text  
At 2:36 AM -0700 2000-05-21, mysqluser php wrote:
>Hi!
>
>I have Mysql 3.22.30. Is there any way to select only
>those columns which are not null? If Yes how? If no
>then any other way?
>If upgradition is solution, then will it effect my
>present installed PHP3( installed from RPM compiled
>for mysql) with Mysql & Apache sever.


WHERE col_name IS NOT NULL


If you're trying to use WHERE col_name != NULL, that won't work.
To test against NULL, you need to use IS NULL or IS NOT NULL.

-- 
Paul DuBois, paul@stripped
Thread
select only not null columns.mysqluser php21 May
  • Re: select only not null columns.Paul DuBois21 May
Re: select only not null columns.mysqluser php22 May
  • Re: select only not null columns.Paul DuBois22 May