Thank you for the link but seeing that I am still new with MySQL , this does not mean anything to me.
From: prabhat kumar [mailto:aim.prab...@gmail.com] Sent: 08 January 2010 4:22 PM To: machiel.richards Cc: mysql@lists.mysql.com Subject: Re: FW: MySQL export and import into Oracle http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_ if On Fri, Jan 8, 2010 at 5:52 PM, machiel.richards <machiel.richa...@gmail.com> wrote: Hi guys, Can you please assist me in rewriting this query in order to run this against a mysql database? It seems that the decode function does not exist in mysql. select decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No') email_corr, count(*) tot from profiles where email is not null group by (decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No')) -- Best Regards, Prabhat Kumar MySQL DBA Datavail-India Mumbai Mobile : 91-9987681929 www.datavail.com My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat