You can use STR_TO_DATE() to convert your strings to MySQL date values and ORDER BY the result:
ORDER BY STR_TO_DATE(datestring, '%d/%m/%Y')
However, you would be wise to convert the column to the DATE data type instead of using strings.
You can use STR_TO_DATE() to convert your strings to MySQL date values and ORDER BY the result:
ORDER BY STR_TO_DATE(datestring, '%d/%m/%Y')
However, you would be wise to convert the column to the DATE data type instead of using strings.