Member Avatar for Venom Rush

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.

  • 1 Contributor
  • 1 Reply
  • 80 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by Venom Rush
Member Avatar for Venom Rush

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

SUBSTRING(columnname, -8)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.