UPDATE wp_posts SET post_content = REPLACE (post_content,'Ã¡','á');
UPDATE wp_posts SET post_title =  REPLACE (post_title,'Ã¡','á');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'Ã¡','á');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'Ã¡','á');
UPDATE wp_links SET link_name =  REPLACE (link_name,'Ã¡','á');
UPDATE wp_options SET option_value =  REPLACE (option_value,'Ã¡','á');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'Ã¡','á');
UPDATE wp_users SET display_name =  REPLACE (display_name,'Ã¡','á');

UPDATE wp_posts SET post_content = REPLACE (post_content,'Ã©','é');
UPDATE wp_posts SET post_title =  REPLACE (post_title,'Ã©','é');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'Ã©','é');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'Ã©','é');
UPDATE wp_links SET link_name =  REPLACE (link_name,'Ã©','é');
UPDATE wp_options SET option_value =  REPLACE (option_value,'Ã©','é');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'Ã©','é');
UPDATE wp_users SET display_name =  REPLACE (display_name,'Ã©','é');

UPDATE wp_posts SET post_content = REPLACE (post_content,'Ã³','ó');
UPDATE wp_posts SET post_title =  REPLACE (post_title,'Ã³','ó');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'Ã³','ó');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'Ã³','ó');
UPDATE wp_links SET link_name =  REPLACE (link_name,'Ã³','ó');
UPDATE wp_options SET option_value =  REPLACE (option_value,'Ã³','ó');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'Ã³','ó');
UPDATE wp_users SET display_name =  REPLACE (display_name,'Ã³','ó');

UPDATE wp_posts SET post_content = REPLACE (post_content,'Â¿','¿');
UPDATE wp_posts SET post_title =  REPLACE (post_title,'Â¿','¿');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'Â¿','¿');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'Â¿','¿');
UPDATE wp_links SET link_name =  REPLACE (link_name,'Â¿','¿');
UPDATE wp_options SET option_value =  REPLACE (option_value,'Â¿','¿');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'Â¿','¿');
UPDATE wp_users SET display_name =  REPLACE (display_name,'Â¿','¿');

UPDATE wp_posts SET post_content = REPLACE (post_content,'Ãº','ú');
UPDATE wp_posts SET post_title =  REPLACE (post_title,'Ãº','ú');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'Ãº','ú');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'Ãº','ú');
UPDATE wp_links SET link_name =  REPLACE (link_name,'Ãº','ú');
UPDATE wp_options SET option_value =  REPLACE (option_value,'Ãº','ú');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'Ãº','ú');
UPDATE wp_users SET display_name =  REPLACE (display_name,'Ãº','ú');

UPDATE wp_posts SET post_content = REPLACE (post_content,'Ã±','ñ');
UPDATE wp_posts SET post_title =  REPLACE (post_title,'Ã±','ñ');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'Ã±','ñ');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'Ã±','ñ');
UPDATE wp_links SET link_name =  REPLACE (link_name,'Ã±','ñ');
UPDATE wp_options SET option_value =  REPLACE (option_value,'Ã±','ñ');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'Ã±','ñ');
UPDATE wp_users SET display_name =  REPLACE (display_name,'Ã±','ñ');

UPDATE wp_posts SET post_content = REPLACE(REPLACE(post_content,CHAR(173),''), CHAR(195), 'í'); 
UPDATE wp_posts SET post_title =  REPLACE(REPLACE(post_title,CHAR(173),''), CHAR(195), 'í'); 
UPDATE wp_comments SET comment_content =  REPLACE(REPLACE(comment_content,CHAR(173),''), CHAR(195), 'í'); 
UPDATE wp_comments SET comment_author =  REPLACE(REPLACE(comment_author,CHAR(173),''), CHAR(195), 'í'); 
UPDATE wp_links SET link_name =  REPLACE(REPLACE(link_name,CHAR(173),''), CHAR(195), 'í'); 
UPDATE wp_options SET option_value =  REPLACE(REPLACE(option_value,CHAR(173),''), CHAR(195), 'í'); 
UPDATE wp_usermeta SET meta_value =  REPLACE(REPLACE(meta_value,CHAR(173),''), CHAR(195), 'í'); 
UPDATE wp_users SET display_name =  REPLACE(REPLACE(display_name,CHAR(173),''), CHAR(195), 'í'); 

UPDATE wp_posts SET post_content = REPLACE (post_content,'Â´','´');
UPDATE wp_posts SET post_title =  REPLACE (post_title,'Â´','´');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'Â´','´');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'Â´','´');
UPDATE wp_links SET link_name =  REPLACE (link_name,'Â´','´');
UPDATE wp_options SET option_value =  REPLACE (option_value,'Â´','´');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'Â´','´');
UPDATE wp_users SET display_name =  REPLACE (display_name,'Â´','´');

UPDATE wp_posts SET post_content = REPLACE (post_content,'â€œ','“');
UPDATE wp_posts SET post_title =  REPLACE (post_title,'â€œ','“');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'â€œ','“');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'â€œ','“');
UPDATE wp_links SET link_name =  REPLACE (link_name,'â€œ','“');
UPDATE wp_options SET option_value =  REPLACE (option_value,'â€œ','“');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'â€œ','“');
UPDATE wp_users SET display_name =  REPLACE (display_name,'â€œ','“');

UPDATE wp_posts SET post_content = REPLACE (post_content,'Â  ',' ');
UPDATE wp_posts SET post_title =  REPLACE (post_title,'Â  ',' ');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'Â  ',' ');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'Â  ',' ');
UPDATE wp_links SET link_name =  REPLACE (link_name,'Â  ',' ');
UPDATE wp_options SET option_value =  REPLACE (option_value, 'Â  ',' ');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'Â  ',' ');
UPDATE wp_users SET display_name =  REPLACE (display_name,'Â  ',' ');

UPDATE wp_posts SET post_content = REPLACE(REPLACE(post_content,CHAR(144),''), 'â€', '”'); 
UPDATE wp_posts SET post_title =  REPLACE(REPLACE(post_title,CHAR(144),''), 'â€', '”'); 
UPDATE wp_comments SET comment_content =  REPLACE(REPLACE(comment_content,CHAR(144),''), 'â€', '”'); 
UPDATE wp_comments SET comment_author =  REPLACE(REPLACE(comment_author,CHAR(144),''), 'â€', '”'); 
UPDATE wp_links SET link_name =  REPLACE(REPLACE(link_name,CHAR(144),''), 'â€', '”'); 
UPDATE wp_options SET option_value =  REPLACE(REPLACE(option_value,CHAR(144),''), 'â€', '”'); 
UPDATE wp_usermeta SET meta_value =  REPLACE(REPLACE(meta_value,CHAR(144),''), 'â€', '”'); 
UPDATE wp_users SET display_name =  REPLACE(REPLACE(display_name,CHAR(144),''), 'â€', '”'); 

UPDATE wp_posts SET post_content = REPLACE (post_content,CHAR(157),'');
UPDATE wp_posts SET post_title =  REPLACE (post_title,CHAR(157),'');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,CHAR(157),'');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,CHAR(157),'');
UPDATE wp_links SET link_name =  REPLACE (link_name,CHAR(157),'');
UPDATE wp_options SET option_value =  REPLACE (option_value,CHAR(157),'');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,CHAR(157),'');
UPDATE wp_users SET display_name =  REPLACE (display_name,CHAR(157),'');

UPDATE wp_posts SET post_content = REPLACE (post_content,',Â','´');
UPDATE wp_posts SET post_title =  REPLACE (post_title,'Â´','´');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,'Â´','´');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,'Â´','´');
UPDATE wp_links SET link_name =  REPLACE (link_name,'Â´','´');
UPDATE wp_options SET option_value =  REPLACE (option_value,'Â´','´');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,'Â´','´');
UPDATE wp_users SET display_name =  REPLACE (display_name,'Â´','´');

UPDATE wp_posts SET post_content = REPLACE (post_content,',Â',',');
UPDATE wp_posts SET post_title =  REPLACE (post_title,',Â',',');
UPDATE wp_comments SET comment_content =  REPLACE (comment_content,',Â',',');
UPDATE wp_comments SET comment_author =  REPLACE (comment_author,',Â',',');
UPDATE wp_links SET link_name =  REPLACE (link_name,',Â',',');
UPDATE wp_options SET option_value =  REPLACE (option_value,',Â',',');
UPDATE wp_usermeta SET meta_value =  REPLACE (meta_value,',Â',',');
UPDATE wp_users SET display_name =  REPLACE (display_name,',Â',',');
