On Thu, Jul 31, 2008 at 8:00 AM, Fish Kungfu <[EMAIL PROTECTED]> wrote: > Ideally, I was hoping COUNT() could work like this, BUT it doesn't of > course: > > mysql> SELECT COUNT(SELECT aviName,MAX(dateTime) ,count(*) FROM > aviTrackerMain WHERE DATE(dateTime) LIKE CONCAT(DATE(NOW()),'%') GROUP > BY aviName);
SELECT COUNT(DISTINCT aviName); I don't really understand why you don't want to just look at the number of rows you get from the first query though. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]