On Fri, May 23, 2008 at 8:23 AM, Tuc at T-B-O-H.NET <[EMAIL PROTECTED]> wrote: > Hi, > > I'm running a query : > > SELECT SUM(AcctSessionTime) FROM radacct WHERE UserName='hotspot'; > > But if there aren't any rows in "radacct" for the UserName of > "hotspot", it returns a NULL. Is there a way to change it to return 0 > instead? (I can't change the application, but I can change the SQL) >
SELECT IFNULL( SUM(AcctSessionTime),0) FROM radacct WHERE UserName='hotspot'; -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]