Re: mysql have same function mthod as Oracle decode()

2004-03-23 Thread Egor Egorov
"Qiang.zhou" <[EMAIL PROTECTED]> wrote: > 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 Use IF() or CASE to rewrite your query: http://www.mysql.com/doc/en/Co

mysql have same function mthod as Oracle decode()

2004-03-22 Thread 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