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]
