select case consider the first field only, MySQL 4.18

[Jan Bartholdy]

Dear List, I have a select case question

SELECT CASE WHEN `Species_1_l` > 0
             THEN 'intern'
        when 'Species_3_e' > 0
        THEN 'extern'
             ELSE ''
         END AS `species_1_l` from species where statsample=1820;

The result is only 

--------------
species_1_l  

intern

--------------
 The second and third etc. fields are not considered.

Species_1_l contains: "34"
Species_3_e contains: "88", so the result of select case should be "intern"
and "extern".

Fields are INT(11), standard value NULL

Thanks for help, Jan

_


____________
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]