mysql have same function mthod as Oracle decode()

[Qiang.zhou]

Dear All;

   At oracle8i i can write this sql:
   select decode(a.id,null,'NULL',2,"God',3,'Norma','Animal') from user

   Then i want know ,how to write this at mysql4.1 

Thanks