At 2:17 PM -0700 2000-05-21, mysqluser php wrote:
>Dear Paul DuBois
>Thanks for reply. But I think my problem is some what
>different, let me explain it more.
>My table has one row , 8 columns. out of this 8
>columns i want to read (select) only columns those
>have value. i.e. not null. How to do this?
If this means you want to select a variable number of columns,
depending on which ones are or are not NULL, I'm not sure how
to do this. A SELECT statement always selects the same number
of columns per row. Perhaps you can get tricky and use the
IFNULL() function, one test per column, and combine each test
with CONCAT() or something.
>--- Paul DuBois <paul@stripped> wrote:
>> At 2:36 AM -0700 2000-05-21, mysqluser php wrote:
>> >I have Mysql 3.22.30. Is there any way to select
>> >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
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
Paul DuBois, paul@stripped