Repairing utf8 broken characters

Sometimes during data table backup or migration, you may end up having broken utf8 characters. A easy way to solve the problem is following the below SQL Query:

1
2

UPDATE table_name SET column_name = 
    CONVERT(BINARY CONVERT(column_name USING latin1) USING utf8);