There are several way to achieve your goal
1. Convert your string to date[time]
SELECT `date_column`
FROM `your_table`
ORDER BY str_to_date(`date_column`, '%d/%m/%Y') DESC
2. Reformat your date string to yyyy-mm-dd (or yyyy/mm/dd etc)
SELECT `date_column`
FROM `your_table`
...
ORDER BY CONCAT_WS('-', SUBSTRING(`date_column`, 7, 4), SUBSTRING(`date_column`, 4, 2), SUBSTRING(`date_column`, 1, 2)) DESC
3. Order by years, months and days separately
SELECT `date_column`
FROM `your_table`
...
ORDER BY CAST(SUBSTRING(`date_column`, 7, 4) AS INT), CAST(SUBSTRING(`date_column`, 4, 2) AS INT), CAST(SUBSTRING(`date_column`, 1, 2)) AS INT) DESC
Submit an article or tip