utf 8 - Detecting utf8 broken characters in MySQL

Question

I've got a database with a bunch of broken utf8 characters scattered across several tables. The list of characters isn't very extensive AFAIK (áéíúóáéíóú??)

Fixing a given table is very straightforward

update orderItem set itemName=replace(itemName,'??','á');

But I can't get a way of detecting the broken characters. If I do something like

SELECT * FROM TABLE WHERE field LIKE "%?%";

I get nearly all the fields because of the collation (?=a). All broken characters so far start with an "?". The database is in spanish so this particular character isn't used

The list of broken chars I've got so far is

?? = á
?? = é
?-- = í
?3 = ó
?± = ?
?? = á

Any idea of how to make this SELECT to work as intended? (a binary search or something like that)

Answer 1

I fixed with

UPDATE wp_zcs9ck_posts_copy SET post_title = 
    CONVERT(BINARY CONVERT(post_title USING latin1) USING utf8);

Complete solution: http://jonisalonen.com/2012/fixing-doubly-utf-8-encoded-text-in-mysql/