Mysql Query Question - ordering by date when date is stored in VARCHAR column
Posted on 2009-07-16
I'm trying to update a MySQL query so that it displays the records in reverse chronological order based on the "entry_date" value -- but the dates are stored in a VARCHAR column, which is making the records display in the wrong order.
How can I update the following MySQL query so that it displays the records in reverse chronological order based on the date in this situation?
SELECT ID,title,location,entry_date, article_text FROM newsevents WHERE entry_type!='EVENT' AND archive='0' AND publish_main='1' ORDER BY entry_date DESC