Sort by Date Stored in Text Field with PHP

The following code will convert the string into a datetime datatype.


STR_TO_DATE(datestring, '%m/%d/%Y')


To change the format of the date displayed, use DATE_FORMAT.


DATE_FORMAT(STR_TO_DATE(datestring, '%m/%d/%Y'), '%Y-%m-%d')