How can I decode UTF-8 encoded data from a MySQL table with Latin1 character set?

If you have UTF-8 encoded data in a MySQL table that has character set set to Latin1 you can use the following SQL statement to correctly decode it:

SELECT CAST(BINARY(value) AS CHAR CHARACTER SET utf8) AS value