mysql equivalent of oracle's DECODE

[Anon]

is there something similar for a IF-THEN_ELSE condition in mysql?

thanks

[[deleted]]

Why don't you just look it up in the manual?
www.mysql.com

SELECT if(field1=2,field3,field5) FROM table;