| 1 | UPDATE wp_posts SET post_content = REPLACE (post_content,'á','á');
|
|---|
| 2 | UPDATE wp_posts SET post_title = REPLACE (post_title,'á','á');
|
|---|
| 3 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,'á','á');
|
|---|
| 4 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,'á','á');
|
|---|
| 5 | UPDATE wp_links SET link_name = REPLACE (link_name,'á','á');
|
|---|
| 6 | UPDATE wp_options SET option_value = REPLACE (option_value,'á','á');
|
|---|
| 7 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,'á','á');
|
|---|
| 8 | UPDATE wp_users SET display_name = REPLACE (display_name,'á','á');
|
|---|
| 9 |
|
|---|
| 10 | UPDATE wp_posts SET post_content = REPLACE (post_content,'é','é');
|
|---|
| 11 | UPDATE wp_posts SET post_title = REPLACE (post_title,'é','é');
|
|---|
| 12 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,'é','é');
|
|---|
| 13 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,'é','é');
|
|---|
| 14 | UPDATE wp_links SET link_name = REPLACE (link_name,'é','é');
|
|---|
| 15 | UPDATE wp_options SET option_value = REPLACE (option_value,'é','é');
|
|---|
| 16 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,'é','é');
|
|---|
| 17 | UPDATE wp_users SET display_name = REPLACE (display_name,'é','é');
|
|---|
| 18 |
|
|---|
| 19 | UPDATE wp_posts SET post_content = REPLACE (post_content,'ó','ó');
|
|---|
| 20 | UPDATE wp_posts SET post_title = REPLACE (post_title,'ó','ó');
|
|---|
| 21 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,'ó','ó');
|
|---|
| 22 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,'ó','ó');
|
|---|
| 23 | UPDATE wp_links SET link_name = REPLACE (link_name,'ó','ó');
|
|---|
| 24 | UPDATE wp_options SET option_value = REPLACE (option_value,'ó','ó');
|
|---|
| 25 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,'ó','ó');
|
|---|
| 26 | UPDATE wp_users SET display_name = REPLACE (display_name,'ó','ó');
|
|---|
| 27 |
|
|---|
| 28 | UPDATE wp_posts SET post_content = REPLACE (post_content,'¿','¿');
|
|---|
| 29 | UPDATE wp_posts SET post_title = REPLACE (post_title,'¿','¿');
|
|---|
| 30 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,'¿','¿');
|
|---|
| 31 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,'¿','¿');
|
|---|
| 32 | UPDATE wp_links SET link_name = REPLACE (link_name,'¿','¿');
|
|---|
| 33 | UPDATE wp_options SET option_value = REPLACE (option_value,'¿','¿');
|
|---|
| 34 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,'¿','¿');
|
|---|
| 35 | UPDATE wp_users SET display_name = REPLACE (display_name,'¿','¿');
|
|---|
| 36 |
|
|---|
| 37 | UPDATE wp_posts SET post_content = REPLACE (post_content,'ú','ú');
|
|---|
| 38 | UPDATE wp_posts SET post_title = REPLACE (post_title,'ú','ú');
|
|---|
| 39 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,'ú','ú');
|
|---|
| 40 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,'ú','ú');
|
|---|
| 41 | UPDATE wp_links SET link_name = REPLACE (link_name,'ú','ú');
|
|---|
| 42 | UPDATE wp_options SET option_value = REPLACE (option_value,'ú','ú');
|
|---|
| 43 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,'ú','ú');
|
|---|
| 44 | UPDATE wp_users SET display_name = REPLACE (display_name,'ú','ú');
|
|---|
| 45 |
|
|---|
| 46 | UPDATE wp_posts SET post_content = REPLACE (post_content,'ñ','ñ');
|
|---|
| 47 | UPDATE wp_posts SET post_title = REPLACE (post_title,'ñ','ñ');
|
|---|
| 48 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,'ñ','ñ');
|
|---|
| 49 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,'ñ','ñ');
|
|---|
| 50 | UPDATE wp_links SET link_name = REPLACE (link_name,'ñ','ñ');
|
|---|
| 51 | UPDATE wp_options SET option_value = REPLACE (option_value,'ñ','ñ');
|
|---|
| 52 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,'ñ','ñ');
|
|---|
| 53 | UPDATE wp_users SET display_name = REPLACE (display_name,'ñ','ñ');
|
|---|
| 54 |
|
|---|
| 55 | UPDATE wp_posts SET post_content = REPLACE(REPLACE(post_content,CHAR(173),''), CHAR(195), 'í');
|
|---|
| 56 | UPDATE wp_posts SET post_title = REPLACE(REPLACE(post_title,CHAR(173),''), CHAR(195), 'í');
|
|---|
| 57 | UPDATE wp_comments SET comment_content = REPLACE(REPLACE(comment_content,CHAR(173),''), CHAR(195), 'í');
|
|---|
| 58 | UPDATE wp_comments SET comment_author = REPLACE(REPLACE(comment_author,CHAR(173),''), CHAR(195), 'í');
|
|---|
| 59 | UPDATE wp_links SET link_name = REPLACE(REPLACE(link_name,CHAR(173),''), CHAR(195), 'í');
|
|---|
| 60 | UPDATE wp_options SET option_value = REPLACE(REPLACE(option_value,CHAR(173),''), CHAR(195), 'í');
|
|---|
| 61 | UPDATE wp_usermeta SET meta_value = REPLACE(REPLACE(meta_value,CHAR(173),''), CHAR(195), 'í');
|
|---|
| 62 | UPDATE wp_users SET display_name = REPLACE(REPLACE(display_name,CHAR(173),''), CHAR(195), 'í');
|
|---|
| 63 |
|
|---|
| 64 | UPDATE wp_posts SET post_content = REPLACE (post_content,'´','´');
|
|---|
| 65 | UPDATE wp_posts SET post_title = REPLACE (post_title,'´','´');
|
|---|
| 66 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,'´','´');
|
|---|
| 67 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,'´','´');
|
|---|
| 68 | UPDATE wp_links SET link_name = REPLACE (link_name,'´','´');
|
|---|
| 69 | UPDATE wp_options SET option_value = REPLACE (option_value,'´','´');
|
|---|
| 70 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,'´','´');
|
|---|
| 71 | UPDATE wp_users SET display_name = REPLACE (display_name,'´','´');
|
|---|
| 72 |
|
|---|
| 73 | UPDATE wp_posts SET post_content = REPLACE (post_content,'“','“');
|
|---|
| 74 | UPDATE wp_posts SET post_title = REPLACE (post_title,'“','“');
|
|---|
| 75 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,'“','“');
|
|---|
| 76 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,'“','“');
|
|---|
| 77 | UPDATE wp_links SET link_name = REPLACE (link_name,'“','“');
|
|---|
| 78 | UPDATE wp_options SET option_value = REPLACE (option_value,'“','“');
|
|---|
| 79 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,'“','“');
|
|---|
| 80 | UPDATE wp_users SET display_name = REPLACE (display_name,'“','“');
|
|---|
| 81 |
|
|---|
| 82 | UPDATE wp_posts SET post_content = REPLACE (post_content,'Â ',' ');
|
|---|
| 83 | UPDATE wp_posts SET post_title = REPLACE (post_title,'Â ',' ');
|
|---|
| 84 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,'Â ',' ');
|
|---|
| 85 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,'Â ',' ');
|
|---|
| 86 | UPDATE wp_links SET link_name = REPLACE (link_name,'Â ',' ');
|
|---|
| 87 | UPDATE wp_options SET option_value = REPLACE (option_value, 'Â ',' ');
|
|---|
| 88 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,'Â ',' ');
|
|---|
| 89 | UPDATE wp_users SET display_name = REPLACE (display_name,'Â ',' ');
|
|---|
| 90 |
|
|---|
| 91 | UPDATE wp_posts SET post_content = REPLACE(REPLACE(post_content,CHAR(144),''), 'â€', '”');
|
|---|
| 92 | UPDATE wp_posts SET post_title = REPLACE(REPLACE(post_title,CHAR(144),''), 'â€', '”');
|
|---|
| 93 | UPDATE wp_comments SET comment_content = REPLACE(REPLACE(comment_content,CHAR(144),''), 'â€', '”');
|
|---|
| 94 | UPDATE wp_comments SET comment_author = REPLACE(REPLACE(comment_author,CHAR(144),''), 'â€', '”');
|
|---|
| 95 | UPDATE wp_links SET link_name = REPLACE(REPLACE(link_name,CHAR(144),''), 'â€', '”');
|
|---|
| 96 | UPDATE wp_options SET option_value = REPLACE(REPLACE(option_value,CHAR(144),''), 'â€', '”');
|
|---|
| 97 | UPDATE wp_usermeta SET meta_value = REPLACE(REPLACE(meta_value,CHAR(144),''), 'â€', '”');
|
|---|
| 98 | UPDATE wp_users SET display_name = REPLACE(REPLACE(display_name,CHAR(144),''), 'â€', '”');
|
|---|
| 99 |
|
|---|
| 100 | UPDATE wp_posts SET post_content = REPLACE (post_content,CHAR(157),'');
|
|---|
| 101 | UPDATE wp_posts SET post_title = REPLACE (post_title,CHAR(157),'');
|
|---|
| 102 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,CHAR(157),'');
|
|---|
| 103 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,CHAR(157),'');
|
|---|
| 104 | UPDATE wp_links SET link_name = REPLACE (link_name,CHAR(157),'');
|
|---|
| 105 | UPDATE wp_options SET option_value = REPLACE (option_value,CHAR(157),'');
|
|---|
| 106 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,CHAR(157),'');
|
|---|
| 107 | UPDATE wp_users SET display_name = REPLACE (display_name,CHAR(157),'');
|
|---|
| 108 |
|
|---|
| 109 | UPDATE wp_posts SET post_content = REPLACE (post_content,',Â','´');
|
|---|
| 110 | UPDATE wp_posts SET post_title = REPLACE (post_title,'´','´');
|
|---|
| 111 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,'´','´');
|
|---|
| 112 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,'´','´');
|
|---|
| 113 | UPDATE wp_links SET link_name = REPLACE (link_name,'´','´');
|
|---|
| 114 | UPDATE wp_options SET option_value = REPLACE (option_value,'´','´');
|
|---|
| 115 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,'´','´');
|
|---|
| 116 | UPDATE wp_users SET display_name = REPLACE (display_name,'´','´');
|
|---|
| 117 |
|
|---|
| 118 | UPDATE wp_posts SET post_content = REPLACE (post_content,',Â',',');
|
|---|
| 119 | UPDATE wp_posts SET post_title = REPLACE (post_title,',Â',',');
|
|---|
| 120 | UPDATE wp_comments SET comment_content = REPLACE (comment_content,',Â',',');
|
|---|
| 121 | UPDATE wp_comments SET comment_author = REPLACE (comment_author,',Â',',');
|
|---|
| 122 | UPDATE wp_links SET link_name = REPLACE (link_name,',Â',',');
|
|---|
| 123 | UPDATE wp_options SET option_value = REPLACE (option_value,',Â',',');
|
|---|
| 124 | UPDATE wp_usermeta SET meta_value = REPLACE (meta_value,',Â',',');
|
|---|
| 125 | UPDATE wp_users SET display_name = REPLACE (display_name,',Â',',');
|
|---|