sorting - Order By date ASC

Question

I have "date" column in mysql saving the dates with this format
17-09-2014 (DD-MM-YYYY)

I need to sort them ascending, so I used this command:

SELECT * FROM table ORDER BY date ASC

But I found this result:

17-09-2014
18-09-2015
19-09-2014

It should be:

17-09-2014
19-09-2014
18-09-2015

It sorts the day only ASC not the full date

Answer 1

Try this:

SELECT * FROM table ORDER BY STR_TO_DATE(date,'%d-%m-%Y') ASC