Mysql change date format in database

UPDATE DB
SET column = DATE(STR_TO_DATE(column, '%Y-%d-%m'))
WHERE DATE(STR_TO_DATE(column, '%d-%m-%Y')) <> '0000-00-00'