Hi all

I have a little problem. I have a table that has up 300 rows in it. There is a column where a day and date is inserted. The data looks like this:

Monday, 08 March
Tuesday, 09 March
Wednesday, 10 March
Thursday, 11 March
Friday, 12 March

Right now, when I sort this ASC it comes out with Friday being the first displayed and Wednesday being the last displayed. How can I go about displaying this with Monday being the first and Friday being the last?

I don't want to have to edit all 300 entries in order to fix this.

8 Years
Discussion Span
Last Post by Venom Rush

I managed to sort out my issue by using Mysql's substring function

SUBSTRING(columnname, -8)
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.