Change one character on a string?

Hi,

Need sole ligths to do this:
- find all 'ã' on my registers and change it to 'a'

update MYTABLE set FIELD_NAME = replace(FIELD_NAME,'a','ã');

Code (markup):

Problem is: I have words as 'ãnt', 'nãt' or 'ntã' where my ã can be at the beggining, middle or end of the string... this table have more than 33000

Any help, please?

Thank folks

 

Use the MySql equivalent of CHRTRAN() or STRTRAN().