[MYSQL] Update YEAR date only Turn Back
2018-06-12 11:09:12
UPDATE Table_name set Column_date = DATE_ADD (Column_date , INTERVAL 543 YEAR) WHERE YEAR(Column_date )=2018
2018-06-12 11:09:12
UPDATE Table_name set Column_date = DATE_ADD (Column_date , INTERVAL 543 YEAR) WHERE YEAR(Column_date )=2018