probably one of the many replys you'll get on this, but ORDER BY month(start_date)
assuming the column that has the date is start_date On Thursday 10 July 2003 14:51, Mike At Spy wrote: > I am trying to create an order by in a select statement that takes a > standard 'date' column in a table and sorts the returned data by the month > of that date. > > Off hand, I tried > > ORDER BY start_date(m) > > And I know that is wrong. Anyone have any suggestions? > > Thanks, > > -Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]