For an error, I have entered records in a table with the accents of the type о, о.
Normally we save the records with the correct accents. So I would like to know if there are any questions that you can apply to the table to replace those or with their corresponding letter with your accent.
Greetings
If you are clear about the correspondence between those that are wrong and how they should be, you can use a replace (the characters that I have put do not have to be the correct ones):
UPDATE tabla SET campo = REPLACE(campo, 'ó', 'á');
One thing to keep in mind is that, depending on the database engine, the REPLACE function will exist or it will be called differently