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

Jan Bartholdy wrote: 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' What is the value o

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

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' _