So I have to fall back to ordering by date of insertion, which is stored as:
Thursday 10th of February 2005 10:52:54 AM
However, these are stored as VARCHAR, which I did very early on -- a mistake, I know!
I'd like to order by them on retrieval.
Is there any way to get mysql to do the parsing instead of PHP?