>
> 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';
>
Exactly what I need, thanks...
I didn't see anything like that on the headers of :
http://dev.mysql.com/doc/refman/5.0/en/select.html
otherwise I wouldn't have asked. Thanks!
Tuc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
