Updating Value in MySQL to replace dodgy UTF8 Characters

Nice and quick and simple, just replace the dodgy code with the right one.

Also works with text strings:

UPDATE catalog_product_entity_varchar
 SET value = REPLACE(value,'Ã‚Â','')