Hi, Is there a short way to return the results from a query grouped by months and return zero if no results found: eg:
SELECT count(*) as total, monthname(col) FROM table GROUP BY monthname(col) To return: 5 - Jan 0 - Feb 3 - Mar 0 - Apr etc. Just wondering. I know the long way to do it, by quering each month one by one... Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
