SELECT aviName,MAX(dateTime) ,count(*) FROM aviTrackerMain WHERE DATE(dateTime) LIKE CONCAT(DATE(NOW()),'%') GROUP BY aviName;
This will also give you count of rows On 7/31/08, Fish Kungfu <[EMAIL PROTECTED]> wrote: > > Using MySQL commands only (not PHP's mysql_num_rows), is there a way to > COUNT the number of rows returned from a SELECT.....GROUP BY? > > My primary SELECT query is this: > > SELECT aviName,MAX(dateTime) FROM aviTrackerMain WHERE DATE(dateTime) > LIKE CONCAT(DATE(NOW()),'%') GROUP BY aviName; > > And it faithfully returns x-number of rows. However, I want to be able > to capture the number of rows it returns. If I have to I will use PHP, > but I was hoping for a way to do it with just MySQL. > > > Thanks very much in advance......Fish > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >