mysql对应decode_MySQL相当于Oracle中的DECODE函数

I am trying to find an equivalent of DECODE function in MySQL. It works like this:

Select Name, DECODE(Age,

13,'Thirteen',14,'Fourteen',15,'Fifteen',16,'Sixteen',

17,'Seventeen',18,'Eighteen',19,'Nineteen',

'Adult') AS AgeBracket

FROM Person

The DECODE function will compare value of column 'Age' with 13, 14, 15.. and return appropriate string value 'Thirteen', 'Fourteen'.. and if it matches with nothing, then default value of 'Adult' will be returned.

Any ideas which function in MySQL can do this job? Thanks.

CLARIFICATION: I agree using CASE is one way of achieving desired result, but I am rather looking for a function because of performance and other reasons.

解决方案

You can use IF() where in Oracle you would have used DECODE().

mysql> select if(emp_id=1,'X','Y') as test, emp_id from emps;