Fw: Sorting by abbr weekdays

maps filter fodder: MySQL > Hi Terence, > > > Is there a way to sort records based on a particular column, varchar(3), > > which contains days of the week, mon, tue, wed, thu, fri, sat, sun > > > > I need the order to be mon, tue, wed, thu etc. > > > > Select day_of_week from my_timetable > > ord

Sorting by abbr weekdays

Hi all, Is there a way to sort records based on a particular column, varchar(3), which contains days of the week, mon, tue, wed, thu, fri, sat, sun I need the order to be mon, tue, wed, thu etc. Select day_of_week from my_timetable order by day_of_week Gives >fri >mon >sat >sun >thu >tue >wed