I need to convert dates in the format below into mysql date format. If I try to change the column type to date, it wipes out the data.
+-------------+ | 26-Jan-2001 | | 26-Jan-2001 | | 15-Apr-2001 | | 1-Nov-2001 | | 31-Oct-2001 | | 26-Jan-2001 | | 22-Jun-2001 | | 23-Jul-2000 | | 1-Nov-2001 | | 31-May-2000 | | 17-Nov-2000 | | 10-May-2001 | | 15-Apr-2001 | | 17-May-2001 | | 29-Mar-2000 | | 30-Aug-2001 | | 18-May-2000 | | 11-Apr-2000 | | 1-Nov-2001 | | 24-Feb-2000 | +-------------+
