I have a varchar field called date that looks like this "2/06/2011 TUE" or like this "10/05/2011 WED".
When I do an Order BY date Desc in php it does Not sort properly.
Thanks for your assistance
Steve
How to sort a varchar field with "/"
Moderator: General Moderators
Re: How to sort a varchar field with "/"
You could try ORDER BY UNIX_TIMESTAMP(date) DESC
Or some other mysql date/time functions
Or some other mysql date/time functions
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.