while I could write a script to do this in PHP, I am hoping there is a simple MySQL way to change date / times strings like this:
that got imported as VARCHAR(35) into date time so that when I sort by that column in ascending order, it actually sorts properly.
I tried altering the table to change that column to a datatime type, but that ckilled the data. (I didn't think it would work, but hey... it's worth a try). Then I restored from a backup, and tried this:
SELECT *,DATE('Recieved') AS RealDate FROM `emails`
But that didn't work either....