WG: select case consider the first field only, MySQL 4.0.18

[Jan Bartholdy]

 Thanks Roger, but it does not work:
 
 SELECT CASE
 when Species_1_e > 0
        THEN 'extern'
 when Species_3_e > 0
        THEN 'intern'
              ELSE ''
          END AS `species_1_l` from species where statsample=1820;
 
 
 ----------Gives at a result 'extern'
 __________________________________________________________________________
 __
 
 SELECT CASE
 
when Species_1_e > 0
        THEN 'extern'
              ELSE ''
          END AS `species_1_l` from species where statsample=1820;
 
 
 ----------Gives at a result 'extern'
 
 
 __________________________________________________________________________
 __and finally,
 
 SELECT CASE
 
 when Species_3_e > 0
        THEN 'intern'
              ELSE ''
          END AS `species_1_l` from species where statsample=1820;
 
 ----------Gives at a result 'intern'
 
 I do not understand, why I can't get extern, intern as a result from this
 selection.
 
 The background is that I have a table with 195 rows and 1000 colums,
 including counting data from species distributions of single samples. 999
 species are the inventar of the whole area, but not all are present in
 each single sample (row). I want to select only columns from single rows,
 containing values > 0, or not NULL.
 Thanks for the help, Jan
 
 
 > -----Urspr�ngliche Nachricht-----
> > Von: Roger Baklund [mailto:[EMAIL PROTECTED]
> > Gesendet: Freitag, 18. Februar 2005 13:27
> > An: mysql@lists.mysql.com
> > Cc: Jan Bartholdy
> > Betreff: Re: select case consider the first field only, MySQL 4.18
> >
> > Jan Bartholdy wrote:
> > > Dear List, I have a select case question
> > >
> > > SELECT CASE WHEN `Species_1_l` > 0
> > >              THEN 'intern'
> > >   when 'Species_3_e' > 0
> >
> > 'Species_3_e' is surrounded by single quotes, not backticks... thus it
> > is treated as a string, numeric value is 0, which is never > 0.
> >
> > BTW, there is no version 4.18, you probably meant 4.0.18.
> >
> > --
> > Roger
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
> > bartholdy.de
> 
> 
> ____________
> Virus checked by G DATA AntiVirusKit
> Version: AVK 15.0.2975 from 09.02.2005


____________
Virus checked by G DATA AntiVirusKit
Version: AVK 15.0.2975 from 09.02.2005


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]