title: MySQL equivalent of DECODE function in Oracle
body: <p>I am trying to find an equivalent of DECODE function in MySQL. It works like this:</p>
  
  <pre><code>Select Name, DECODE(Age,
         13,'Thirteen',14,'Fourteen',15,'Fifteen',16,'Sixteen',
         17,'Seventeen',18,'Eighteen',19,'Nineteen',
         'Adult') AS AgeBracket
  FROM Person
  </code></pre>
  
  <p>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.</p>
  
  <p>Any ideas which function in MySQL can do this job? Thanks.</p>
  
  <p>CLARIFICATION: I agree using CASE is one way of achieving desired result, but I am rather looking for a <strong><em>function</em></strong> because of performance and other reasons.</p>