Search and replace characters in a MySQL table

[ocon]

I discovered I incorrectly imported data into my database as some accented characters are corrupted.

For example, instead of "Tucumán" I get "Tucumán".

I've made changes to this data so I don't want to dump it and reimport it but try to salvage it if I can.

I noticed each character corrupts the same way:

á=>á
ç=>ç
ã=>ã
º=>º

Is there a command I can use to search and replace strings in the table across all the columns? Or maybe some even better fix?

[coopster]

If your rows have last update timestamps you could narrow down which rows have not been updated yet since the initial import and you could update just those rows.