I have a MySQL table with a Date column in format \"YYYY-MM-DD\" and I\'m trying to figure out a query that would return a list of months that have an entry in the above table. With output like:
Mar-01, Feb-01, Apr-01 etc... I\'m still pretty new to MySQL and the date functions are still a bit confusing to me. Would something like this work? \"SELECT (DATE_FORMAT( DateCol, \"%b-%Y\") AS MonthWithEntry) FROM BlogTable;\" I think that would work but how do I get it to return only 1 row per month with entries rather than 1 row per entry that month? Cheers, Danielb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]