Re: Oracle nvl function equivalent.

[Ed Leafe]

On Jan 4, 2004, at 7:09 PM, Arun Natarajan wrote:

Is there an equivalent to the nvl() function of Oracle available in 
MySql. I
am currently using version 4.1 alpha and am trying to execute the 
following
query:
Select count(nvl(col1,1)) as col1 from table1 group by col1;
	In MySQL, the function is called IFNULL().

     ___/
    /
   __/
  /
 ____/
 Ed Leafe
Linux Love:
unzip;strip;touch;finger;mount;fsck;more;yes;umount;sleep
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]