Replace all characters in strings in database for others?

Question

I want to replace all 'á' in table Cities and column Domain for 'a'.

EG:

ID   Domain
1    árbol
2    megá

RESULT:

ID   Domain
1    arbol
2    mega

How can this be done?

Answer 1

UPDATE Cities
   SET Domain = REPLACE(Domain,'á','a');