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
