Skip to content

Instantly share code, notes, and snippets.

@boogah
Last active September 28, 2021 21:14
Show Gist options
  • Save boogah/d624a4c715ec7e938281623ebf8a5dcf to your computer and use it in GitHub Desktop.
Save boogah/d624a4c715ec7e938281623ebf8a5dcf to your computer and use it in GitHub Desktop.
Import these SQL files when you see weird crud in your posts/comments/etc. after migrating your WordPress install or upgrading MySQL on your server. *Note:* You may need to do a find/replace on the prefix in each `.sql` file if your WordPress install is not set to use the usual default of `wp_`.
update wp_comments set comment_content = replace(comment_content, 'α', 'α');
update wp_comments set comment_content = replace(comment_content, 'β', 'β');
update wp_comments set comment_content = replace(comment_content, 'γ', 'γ');
update wp_comments set comment_content = replace(comment_content, 'δ', 'δ');
update wp_comments set comment_content = replace(comment_content, 'ε', 'ε');
update wp_comments set comment_content = replace(comment_content, 'ζ', 'ζ');
update wp_comments set comment_content = replace(comment_content, 'η', 'η');
update wp_comments set comment_content = replace(comment_content, 'θ', 'θ');
update wp_comments set comment_content = replace(comment_content, 'ι', 'ι');
update wp_comments set comment_content = replace(comment_content, 'κ', 'κ');
update wp_comments set comment_content = replace(comment_content, 'λ', 'λ');
update wp_comments set comment_content = replace(comment_content, 'μ', 'μ');
update wp_comments set comment_content = replace(comment_content, 'ν', 'ν');
update wp_comments set comment_content = replace(comment_content, 'ξ', 'ξ');
update wp_comments set comment_content = replace(comment_content, 'ο', 'ο');
update wp_comments set comment_content = replace(comment_content, 'Ï€', 'π');
update wp_comments set comment_content = replace(comment_content, 'ρ', 'ρ');
update wp_comments set comment_content = replace(comment_content, 'σ', 'σ');
update wp_comments set comment_content = replace(comment_content, 'Ï„', 'τ');
update wp_comments set comment_content = replace(comment_content, 'Ï…', 'υ');
update wp_comments set comment_content = replace(comment_content, 'φ', 'φ');
update wp_comments set comment_content = replace(comment_content, 'χ', 'χ');
update wp_comments set comment_content = replace(comment_content, 'ψ', 'ψ');
update wp_comments set comment_content = replace(comment_content, 'ω', 'ω');
update wp_comments set comment_content = replace(comment_content, 'Α', 'Α');
update wp_comments set comment_content = replace(comment_content, 'Î’', 'Β');
update wp_comments set comment_content = replace(comment_content, 'Γ', 'Γ');
update wp_comments set comment_content = replace(comment_content, 'Δ', 'Δ');
update wp_comments set comment_content = replace(comment_content, 'Ε', 'Ε');
update wp_comments set comment_content = replace(comment_content, 'Ζ', 'Ζ');
update wp_comments set comment_content = replace(comment_content, 'Η', 'Η');
update wp_comments set comment_content = replace(comment_content, 'Θ', 'Θ');
update wp_comments set comment_content = replace(comment_content, 'Ι', 'Ι');
update wp_comments set comment_content = replace(comment_content, 'Κ', 'Κ');
update wp_comments set comment_content = replace(comment_content, 'Λ', 'Λ');
update wp_comments set comment_content = replace(comment_content, 'Îœ', 'Μ');
update wp_comments set comment_content = replace(comment_content, 'Ν', 'Ν');
update wp_comments set comment_content = replace(comment_content, 'Ξ', 'Ξ');
update wp_comments set comment_content = replace(comment_content, 'Ο', 'Ο');
update wp_comments set comment_content = replace(comment_content, 'Π', 'Π');
update wp_comments set comment_content = replace(comment_content, 'Ρ', 'Ρ');
update wp_comments set comment_content = replace(comment_content, 'Σ', 'Σ');
update wp_comments set comment_content = replace(comment_content, 'Τ', 'Τ');
update wp_comments set comment_content = replace(comment_content, 'Î¥', 'Υ');
update wp_comments set comment_content = replace(comment_content, 'Φ', 'Φ');
update wp_comments set comment_content = replace(comment_content, 'Χ', 'Χ');
update wp_comments set comment_content = replace(comment_content, 'Ψ', 'Ψ');
update wp_comments set comment_content = replace(comment_content, 'Ω', 'Ω');
update wp_comments set comment_content = replace(comment_content, 'ά', 'ά');
update wp_comments set comment_content = replace(comment_content, 'έ', 'έ');
update wp_comments set comment_content = replace(comment_content, 'ή', 'ή');
update wp_comments set comment_content = replace(comment_content, 'ί', 'ί');
update wp_comments set comment_content = replace(comment_content, 'ÏŒ', 'ό');
update wp_comments set comment_content = replace(comment_content, 'ύ', 'ύ');
update wp_comments set comment_content = replace(comment_content, 'ÏŽ', 'ώ');
update wp_comments set comment_content = replace(comment_content, 'Ά', 'Ά');
update wp_comments set comment_content = replace(comment_content, 'Έ', 'Έ');
update wp_comments set comment_content = replace(comment_content, 'Ή', 'Ή');
update wp_comments set comment_content = replace(comment_content, 'Ί', 'Ί');
update wp_comments set comment_content = replace(comment_content, 'ÎŒ', 'Ό');
update wp_comments set comment_content = replace(comment_content, 'ÎŽ', 'Ύ');
update wp_comments set comment_content = replace(comment_content, 'Ώ', 'Ώ');
update wp_comments set comment_content = replace(comment_content, 'Ï‹', 'ϋ');
update wp_comments set comment_content = replace(comment_content, 'ΰ', 'υ');
update wp_comments set comment_content = replace(comment_content, 'ÏŠ', 'ϊ');
update wp_comments set comment_content = replace(comment_content, 'ΐ', 'ι');
update wp_comments set comment_content = replace(comment_content, 'Ï‚', 'ς');
update wp_comments set comment_content = replace(comment_content, '…', '…');
update wp_comments set comment_content = replace(comment_content, '’', '’');
update wp_comments set comment_content = replace(comment_content, 'àƒâ‚¬', 'ä');
update wp_comments set comment_content = replace(comment_content, '‘', '');
update wp_comments set comment_content = replace(comment_content, '“', '“');
update wp_comments set comment_content = replace(comment_content, 'â€�', '”');
update wp_comments set comment_content = replace(comment_content, '‹', '‹');
update wp_comments set comment_content = replace(comment_content, '›', '›');
update wp_comments set comment_content = replace(comment_content, '—', '—');
update wp_comments set comment_content = replace(comment_content, '–', '—');
update wp_comments set comment_content = replace(comment_content, 'â€?', '”');
update wp_comments set comment_content = replace(comment_content, 'àƒ’', 'à');
update wp_comments set comment_content = replace(comment_content, 'â’€’™', '’');
update wp_comments set comment_content = replace(comment_content, 'â’€’œ', '“');
update wp_comments set comment_content = replace(comment_content, 'â’€?', '”');
update wp_comments set comment_content = replace(comment_content, 'àƒ’©', 'é');
update wp_comments set comment_content = replace(comment_content, 'â’€’¦', '');
update wp_comments set comment_content = replace(comment_content, '–', '\•');
update wp_comments set comment_content = replace(comment_content, '€', '€');
update wp_comments set comment_content = replace(comment_content, 'â€', '"');
update wp_comments set comment_content = replace(comment_content, '–', '–');
update wp_comments set comment_content = replace(comment_content, '•', '-');
update wp_comments set comment_content = replace(comment_content, '“', '"');
update wp_comments set comment_content = replace(comment_content, '¡', '¡');
update wp_comments set comment_content = replace(comment_content, '¢', '¢');
update wp_comments set comment_content = replace(comment_content, '£', '£');
update wp_comments set comment_content = replace(comment_content, '¤', '¤');
update wp_comments set comment_content = replace(comment_content, 'Â¥', '¥');
update wp_comments set comment_content = replace(comment_content, '¦', '¦');
update wp_comments set comment_content = replace(comment_content, '§', '§');
update wp_comments set comment_content = replace(comment_content, '¨', '¨');
update wp_comments set comment_content = replace(comment_content, '©', '©');
update wp_comments set comment_content = replace(comment_content, 'ª', 'ª');
update wp_comments set comment_content = replace(comment_content, '«', '«');
update wp_comments set comment_content = replace(comment_content, '¬', '¬');
update wp_comments set comment_content = replace(comment_content, '­', '­');
update wp_comments set comment_content = replace(comment_content, '®', '®');
update wp_comments set comment_content = replace(comment_content, '¯', '¯');
update wp_comments set comment_content = replace(comment_content, '°', '°');
update wp_comments set comment_content = replace(comment_content, '±', '±');
update wp_comments set comment_content = replace(comment_content, '²', '²');
update wp_comments set comment_content = replace(comment_content, '³', '³');
update wp_comments set comment_content = replace(comment_content, '´', '´');
update wp_comments set comment_content = replace(comment_content, 'µ', 'µ');
update wp_comments set comment_content = replace(comment_content, '¶', '¶');
update wp_comments set comment_content = replace(comment_content, '·', '·');
update wp_comments set comment_content = replace(comment_content, '¸', '¸');
update wp_comments set comment_content = replace(comment_content, '¹', '¹');
update wp_comments set comment_content = replace(comment_content, 'º', 'º');
update wp_comments set comment_content = replace(comment_content, '»', '»');
update wp_comments set comment_content = replace(comment_content, '¼', '¼');
update wp_comments set comment_content = replace(comment_content, '½', '½');
update wp_comments set comment_content = replace(comment_content, '¾', '¾');
update wp_comments set comment_content = replace(comment_content, '¿', '¿');
update wp_comments set comment_content = replace(comment_content, 'À', 'À');
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Á');
update wp_comments set comment_content = replace(comment_content, 'Â', 'Â');
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Ã');
update wp_comments set comment_content = replace(comment_content, 'Ä', 'Ä');
update wp_comments set comment_content = replace(comment_content, 'Ã…', 'Å');
update wp_comments set comment_content = replace(comment_content, 'Æ', 'Æ');
update wp_comments set comment_content = replace(comment_content, 'Ç', 'Ç');
update wp_comments set comment_content = replace(comment_content, 'È', 'È');
update wp_comments set comment_content = replace(comment_content, 'É', 'É');
update wp_comments set comment_content = replace(comment_content, 'Ê', 'Ê');
update wp_comments set comment_content = replace(comment_content, 'Ë', 'Ë');
update wp_comments set comment_content = replace(comment_content, 'ÃŒ', 'Ì');
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Í');
update wp_comments set comment_content = replace(comment_content, 'ÃŽ', 'Î');
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Ï');
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Ð');
update wp_comments set comment_content = replace(comment_content, 'Ñ', 'Ñ');
update wp_comments set comment_content = replace(comment_content, 'Ã’', 'Ò');
update wp_comments set comment_content = replace(comment_content, 'Ó', 'Ó');
update wp_comments set comment_content = replace(comment_content, 'Ô', 'Ô');
update wp_comments set comment_content = replace(comment_content, 'Õ', 'Õ');
update wp_comments set comment_content = replace(comment_content, 'Ö', 'Ö');
update wp_comments set comment_content = replace(comment_content, '×', '×');
update wp_comments set comment_content = replace(comment_content, 'Ø', 'Ø');
update wp_comments set comment_content = replace(comment_content, 'Ù', 'Ù');
update wp_comments set comment_content = replace(comment_content, 'Ú', 'Ú');
update wp_comments set comment_content = replace(comment_content, 'Û', 'Û');
update wp_comments set comment_content = replace(comment_content, 'Ãœ', 'Ü');
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Ý');
update wp_comments set comment_content = replace(comment_content, 'Þ', 'Þ');
update wp_comments set comment_content = replace(comment_content, 'ß', 'ß');
update wp_comments set comment_content = replace(comment_content, 'Ã ', 'à');
update wp_comments set comment_content = replace(comment_content, 'á', 'á');
update wp_comments set comment_content = replace(comment_content, 'â', 'â');
update wp_comments set comment_content = replace(comment_content, 'ã', 'ã');
update wp_comments set comment_content = replace(comment_content, 'ä', 'ä');
update wp_comments set comment_content = replace(comment_content, 'Ã¥', 'å');
update wp_comments set comment_content = replace(comment_content, 'æ', 'æ');
update wp_comments set comment_content = replace(comment_content, 'ç', 'ç');
update wp_comments set comment_content = replace(comment_content, 'è', 'è');
update wp_comments set comment_content = replace(comment_content, 'é', 'é');
update wp_comments set comment_content = replace(comment_content, 'ê', 'ê');
update wp_comments set comment_content = replace(comment_content, 'ë', 'ë');
update wp_comments set comment_content = replace(comment_content, 'ì', 'ì');
update wp_comments set comment_content = replace(comment_content, '­­Ã', 'í');
update wp_comments set comment_content = replace(comment_content, 'î', 'î');
update wp_comments set comment_content = replace(comment_content, 'ï', 'ï');
update wp_comments set comment_content = replace(comment_content, 'ð', 'ð');
update wp_comments set comment_content = replace(comment_content, 'ñ', 'ñ');
update wp_comments set comment_content = replace(comment_content, 'ò', 'ò');
update wp_comments set comment_content = replace(comment_content, 'ó', 'ó');
update wp_comments set comment_content = replace(comment_content, 'ô', 'ô');
update wp_comments set comment_content = replace(comment_content, 'õ', 'õ');
update wp_comments set comment_content = replace(comment_content, 'ö', 'ö');
update wp_comments set comment_content = replace(comment_content, '÷', '÷');
update wp_comments set comment_content = replace(comment_content, 'ø', 'ø');
update wp_comments set comment_content = replace(comment_content, 'ù', 'ù');
update wp_comments set comment_content = replace(comment_content, 'ú', 'ú');
update wp_comments set comment_content = replace(comment_content, 'û', 'û');
update wp_comments set comment_content = replace(comment_content, 'ü', 'ü');
update wp_comments set comment_content = replace(comment_content, 'ý', 'ý');
update wp_comments set comment_content = replace(comment_content, 'þ', 'þ');
update wp_comments set comment_content = replace(comment_content, 'ÿ', 'ÿ');
update wp_postmeta set meta_value = replace(meta_value, 'α', 'α');
update wp_postmeta set meta_value = replace(meta_value, 'β', 'β');
update wp_postmeta set meta_value = replace(meta_value, 'γ', 'γ');
update wp_postmeta set meta_value = replace(meta_value, 'δ', 'δ');
update wp_postmeta set meta_value = replace(meta_value, 'ε', 'ε');
update wp_postmeta set meta_value = replace(meta_value, 'ζ', 'ζ');
update wp_postmeta set meta_value = replace(meta_value, 'η', 'η');
update wp_postmeta set meta_value = replace(meta_value, 'θ', 'θ');
update wp_postmeta set meta_value = replace(meta_value, 'ι', 'ι');
update wp_postmeta set meta_value = replace(meta_value, 'κ', 'κ');
update wp_postmeta set meta_value = replace(meta_value, 'λ', 'λ');
update wp_postmeta set meta_value = replace(meta_value, 'μ', 'μ');
update wp_postmeta set meta_value = replace(meta_value, 'ν', 'ν');
update wp_postmeta set meta_value = replace(meta_value, 'ξ', 'ξ');
update wp_postmeta set meta_value = replace(meta_value, 'ο', 'ο');
update wp_postmeta set meta_value = replace(meta_value, 'Ï€', 'π');
update wp_postmeta set meta_value = replace(meta_value, 'ρ', 'ρ');
update wp_postmeta set meta_value = replace(meta_value, 'σ', 'σ');
update wp_postmeta set meta_value = replace(meta_value, 'Ï„', 'τ');
update wp_postmeta set meta_value = replace(meta_value, 'Ï…', 'υ');
update wp_postmeta set meta_value = replace(meta_value, 'φ', 'φ');
update wp_postmeta set meta_value = replace(meta_value, 'χ', 'χ');
update wp_postmeta set meta_value = replace(meta_value, 'ψ', 'ψ');
update wp_postmeta set meta_value = replace(meta_value, 'ω', 'ω');
update wp_postmeta set meta_value = replace(meta_value, 'Α', 'Α');
update wp_postmeta set meta_value = replace(meta_value, 'Î’', 'Β');
update wp_postmeta set meta_value = replace(meta_value, 'Γ', 'Γ');
update wp_postmeta set meta_value = replace(meta_value, 'Δ', 'Δ');
update wp_postmeta set meta_value = replace(meta_value, 'Ε', 'Ε');
update wp_postmeta set meta_value = replace(meta_value, 'Ζ', 'Ζ');
update wp_postmeta set meta_value = replace(meta_value, 'Η', 'Η');
update wp_postmeta set meta_value = replace(meta_value, 'Θ', 'Θ');
update wp_postmeta set meta_value = replace(meta_value, 'Ι', 'Ι');
update wp_postmeta set meta_value = replace(meta_value, 'Κ', 'Κ');
update wp_postmeta set meta_value = replace(meta_value, 'Λ', 'Λ');
update wp_postmeta set meta_value = replace(meta_value, 'Îœ', 'Μ');
update wp_postmeta set meta_value = replace(meta_value, 'Ν', 'Ν');
update wp_postmeta set meta_value = replace(meta_value, 'Ξ', 'Ξ');
update wp_postmeta set meta_value = replace(meta_value, 'Ο', 'Ο');
update wp_postmeta set meta_value = replace(meta_value, 'Π', 'Π');
update wp_postmeta set meta_value = replace(meta_value, 'Ρ', 'Ρ');
update wp_postmeta set meta_value = replace(meta_value, 'Σ', 'Σ');
update wp_postmeta set meta_value = replace(meta_value, 'Τ', 'Τ');
update wp_postmeta set meta_value = replace(meta_value, 'Î¥', 'Υ');
update wp_postmeta set meta_value = replace(meta_value, 'Φ', 'Φ');
update wp_postmeta set meta_value = replace(meta_value, 'Χ', 'Χ');
update wp_postmeta set meta_value = replace(meta_value, 'Ψ', 'Ψ');
update wp_postmeta set meta_value = replace(meta_value, 'Ω', 'Ω');
update wp_postmeta set meta_value = replace(meta_value, 'ά', 'ά');
update wp_postmeta set meta_value = replace(meta_value, 'έ', 'έ');
update wp_postmeta set meta_value = replace(meta_value, 'ή', 'ή');
update wp_postmeta set meta_value = replace(meta_value, 'ί', 'ί');
update wp_postmeta set meta_value = replace(meta_value, 'ÏŒ', 'ό');
update wp_postmeta set meta_value = replace(meta_value, 'ύ', 'ύ');
update wp_postmeta set meta_value = replace(meta_value, 'ÏŽ', 'ώ');
update wp_postmeta set meta_value = replace(meta_value, 'Ά', 'Ά');
update wp_postmeta set meta_value = replace(meta_value, 'Έ', 'Έ');
update wp_postmeta set meta_value = replace(meta_value, 'Ή', 'Ή');
update wp_postmeta set meta_value = replace(meta_value, 'Ί', 'Ί');
update wp_postmeta set meta_value = replace(meta_value, 'ÎŒ', 'Ό');
update wp_postmeta set meta_value = replace(meta_value, 'ÎŽ', 'Ύ');
update wp_postmeta set meta_value = replace(meta_value, 'Ώ', 'Ώ');
update wp_postmeta set meta_value = replace(meta_value, 'Ï‹', 'ϋ');
update wp_postmeta set meta_value = replace(meta_value, 'ΰ', 'υ');
update wp_postmeta set meta_value = replace(meta_value, 'ÏŠ', 'ϊ');
update wp_postmeta set meta_value = replace(meta_value, 'ΐ', 'ι');
update wp_postmeta set meta_value = replace(meta_value, 'Ï‚', 'ς');
update wp_postmeta set meta_value = replace(meta_value, '…', '…');
update wp_postmeta set meta_value = replace(meta_value, '’', '’');
update wp_postmeta set meta_value = replace(meta_value, 'àƒâ‚¬', 'ä');
update wp_postmeta set meta_value = replace(meta_value, '‘', '');
update wp_postmeta set meta_value = replace(meta_value, '“', '“');
update wp_postmeta set meta_value = replace(meta_value, 'â€�', '”');
update wp_postmeta set meta_value = replace(meta_value, '‹', '‹');
update wp_postmeta set meta_value = replace(meta_value, '›', '›');
update wp_postmeta set meta_value = replace(meta_value, '—', '—');
update wp_postmeta set meta_value = replace(meta_value, '–', '—');
update wp_postmeta set meta_value = replace(meta_value, 'â€?', '”');
update wp_postmeta set meta_value = replace(meta_value, 'àƒ’', 'à');
update wp_postmeta set meta_value = replace(meta_value, 'â’€’™', '’');
update wp_postmeta set meta_value = replace(meta_value, 'â’€’œ', '“');
update wp_postmeta set meta_value = replace(meta_value, 'â’€?', '”');
update wp_postmeta set meta_value = replace(meta_value, 'àƒ’©', 'é');
update wp_postmeta set meta_value = replace(meta_value, 'â’€’¦', '');
update wp_postmeta set meta_value = replace(meta_value, '–', '\•');
update wp_postmeta set meta_value = replace(meta_value, '€', '€');
update wp_postmeta set meta_value = replace(meta_value, 'â€', '"');
update wp_postmeta set meta_value = replace(meta_value, '–', '–');
update wp_postmeta set meta_value = replace(meta_value, '•', '-');
update wp_postmeta set meta_value = replace(meta_value, '“', '"');
update wp_postmeta set meta_value = replace(meta_value, '¡', '¡');
update wp_postmeta set meta_value = replace(meta_value, '¢', '¢');
update wp_postmeta set meta_value = replace(meta_value, '£', '£');
update wp_postmeta set meta_value = replace(meta_value, '¤', '¤');
update wp_postmeta set meta_value = replace(meta_value, 'Â¥', '¥');
update wp_postmeta set meta_value = replace(meta_value, '¦', '¦');
update wp_postmeta set meta_value = replace(meta_value, '§', '§');
update wp_postmeta set meta_value = replace(meta_value, '¨', '¨');
update wp_postmeta set meta_value = replace(meta_value, '©', '©');
update wp_postmeta set meta_value = replace(meta_value, 'ª', 'ª');
update wp_postmeta set meta_value = replace(meta_value, '«', '«');
update wp_postmeta set meta_value = replace(meta_value, '¬', '¬');
update wp_postmeta set meta_value = replace(meta_value, '­', '­');
update wp_postmeta set meta_value = replace(meta_value, '®', '®');
update wp_postmeta set meta_value = replace(meta_value, '¯', '¯');
update wp_postmeta set meta_value = replace(meta_value, '°', '°');
update wp_postmeta set meta_value = replace(meta_value, '±', '±');
update wp_postmeta set meta_value = replace(meta_value, '²', '²');
update wp_postmeta set meta_value = replace(meta_value, '³', '³');
update wp_postmeta set meta_value = replace(meta_value, '´', '´');
update wp_postmeta set meta_value = replace(meta_value, 'µ', 'µ');
update wp_postmeta set meta_value = replace(meta_value, '¶', '¶');
update wp_postmeta set meta_value = replace(meta_value, '·', '·');
update wp_postmeta set meta_value = replace(meta_value, '¸', '¸');
update wp_postmeta set meta_value = replace(meta_value, '¹', '¹');
update wp_postmeta set meta_value = replace(meta_value, 'º', 'º');
update wp_postmeta set meta_value = replace(meta_value, '»', '»');
update wp_postmeta set meta_value = replace(meta_value, '¼', '¼');
update wp_postmeta set meta_value = replace(meta_value, '½', '½');
update wp_postmeta set meta_value = replace(meta_value, '¾', '¾');
update wp_postmeta set meta_value = replace(meta_value, '¿', '¿');
update wp_postmeta set meta_value = replace(meta_value, 'À', 'À');
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Á');
update wp_postmeta set meta_value = replace(meta_value, 'Â', 'Â');
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Ã');
update wp_postmeta set meta_value = replace(meta_value, 'Ä', 'Ä');
update wp_postmeta set meta_value = replace(meta_value, 'Ã…', 'Å');
update wp_postmeta set meta_value = replace(meta_value, 'Æ', 'Æ');
update wp_postmeta set meta_value = replace(meta_value, 'Ç', 'Ç');
update wp_postmeta set meta_value = replace(meta_value, 'È', 'È');
update wp_postmeta set meta_value = replace(meta_value, 'É', 'É');
update wp_postmeta set meta_value = replace(meta_value, 'Ê', 'Ê');
update wp_postmeta set meta_value = replace(meta_value, 'Ë', 'Ë');
update wp_postmeta set meta_value = replace(meta_value, 'ÃŒ', 'Ì');
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Í');
update wp_postmeta set meta_value = replace(meta_value, 'ÃŽ', 'Î');
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Ï');
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Ð');
update wp_postmeta set meta_value = replace(meta_value, 'Ñ', 'Ñ');
update wp_postmeta set meta_value = replace(meta_value, 'Ã’', 'Ò');
update wp_postmeta set meta_value = replace(meta_value, 'Ó', 'Ó');
update wp_postmeta set meta_value = replace(meta_value, 'Ô', 'Ô');
update wp_postmeta set meta_value = replace(meta_value, 'Õ', 'Õ');
update wp_postmeta set meta_value = replace(meta_value, 'Ö', 'Ö');
update wp_postmeta set meta_value = replace(meta_value, '×', '×');
update wp_postmeta set meta_value = replace(meta_value, 'Ø', 'Ø');
update wp_postmeta set meta_value = replace(meta_value, 'Ù', 'Ù');
update wp_postmeta set meta_value = replace(meta_value, 'Ú', 'Ú');
update wp_postmeta set meta_value = replace(meta_value, 'Û', 'Û');
update wp_postmeta set meta_value = replace(meta_value, 'Ãœ', 'Ü');
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Ý');
update wp_postmeta set meta_value = replace(meta_value, 'Þ', 'Þ');
update wp_postmeta set meta_value = replace(meta_value, 'ß', 'ß');
update wp_postmeta set meta_value = replace(meta_value, 'Ã ', 'à');
update wp_postmeta set meta_value = replace(meta_value, 'á', 'á');
update wp_postmeta set meta_value = replace(meta_value, 'â', 'â');
update wp_postmeta set meta_value = replace(meta_value, 'ã', 'ã');
update wp_postmeta set meta_value = replace(meta_value, 'ä', 'ä');
update wp_postmeta set meta_value = replace(meta_value, 'Ã¥', 'å');
update wp_postmeta set meta_value = replace(meta_value, 'æ', 'æ');
update wp_postmeta set meta_value = replace(meta_value, 'ç', 'ç');
update wp_postmeta set meta_value = replace(meta_value, 'è', 'è');
update wp_postmeta set meta_value = replace(meta_value, 'é', 'é');
update wp_postmeta set meta_value = replace(meta_value, 'ê', 'ê');
update wp_postmeta set meta_value = replace(meta_value, 'ë', 'ë');
update wp_postmeta set meta_value = replace(meta_value, 'ì', 'ì');
update wp_postmeta set meta_value = replace(meta_value, '­­Ã', 'í');
update wp_postmeta set meta_value = replace(meta_value, 'î', 'î');
update wp_postmeta set meta_value = replace(meta_value, 'ï', 'ï');
update wp_postmeta set meta_value = replace(meta_value, 'ð', 'ð');
update wp_postmeta set meta_value = replace(meta_value, 'ñ', 'ñ');
update wp_postmeta set meta_value = replace(meta_value, 'ò', 'ò');
update wp_postmeta set meta_value = replace(meta_value, 'ó', 'ó');
update wp_postmeta set meta_value = replace(meta_value, 'ô', 'ô');
update wp_postmeta set meta_value = replace(meta_value, 'õ', 'õ');
update wp_postmeta set meta_value = replace(meta_value, 'ö', 'ö');
update wp_postmeta set meta_value = replace(meta_value, '÷', '÷');
update wp_postmeta set meta_value = replace(meta_value, 'ø', 'ø');
update wp_postmeta set meta_value = replace(meta_value, 'ù', 'ù');
update wp_postmeta set meta_value = replace(meta_value, 'ú', 'ú');
update wp_postmeta set meta_value = replace(meta_value, 'û', 'û');
update wp_postmeta set meta_value = replace(meta_value, 'ü', 'ü');
update wp_postmeta set meta_value = replace(meta_value, 'ý', 'ý');
update wp_postmeta set meta_value = replace(meta_value, 'þ', 'þ');
update wp_postmeta set meta_value = replace(meta_value, 'ÿ', 'ÿ');
update wp_posts set post_content = replace(post_content, 'α', 'α');
update wp_posts set post_content = replace(post_content, 'β', 'β');
update wp_posts set post_content = replace(post_content, 'γ', 'γ');
update wp_posts set post_content = replace(post_content, 'δ', 'δ');
update wp_posts set post_content = replace(post_content, 'ε', 'ε');
update wp_posts set post_content = replace(post_content, 'ζ', 'ζ');
update wp_posts set post_content = replace(post_content, 'η', 'η');
update wp_posts set post_content = replace(post_content, 'θ', 'θ');
update wp_posts set post_content = replace(post_content, 'ι', 'ι');
update wp_posts set post_content = replace(post_content, 'κ', 'κ');
update wp_posts set post_content = replace(post_content, 'λ', 'λ');
update wp_posts set post_content = replace(post_content, 'μ', 'μ');
update wp_posts set post_content = replace(post_content, 'ν', 'ν');
update wp_posts set post_content = replace(post_content, 'ξ', 'ξ');
update wp_posts set post_content = replace(post_content, 'ο', 'ο');
update wp_posts set post_content = replace(post_content, 'Ï€', 'π');
update wp_posts set post_content = replace(post_content, 'ρ', 'ρ');
update wp_posts set post_content = replace(post_content, 'σ', 'σ');
update wp_posts set post_content = replace(post_content, 'Ï„', 'τ');
update wp_posts set post_content = replace(post_content, 'Ï…', 'υ');
update wp_posts set post_content = replace(post_content, 'φ', 'φ');
update wp_posts set post_content = replace(post_content, 'χ', 'χ');
update wp_posts set post_content = replace(post_content, 'ψ', 'ψ');
update wp_posts set post_content = replace(post_content, 'ω', 'ω');
update wp_posts set post_content = replace(post_content, 'Α', 'Α');
update wp_posts set post_content = replace(post_content, 'Î’', 'Β');
update wp_posts set post_content = replace(post_content, 'Γ', 'Γ');
update wp_posts set post_content = replace(post_content, 'Δ', 'Δ');
update wp_posts set post_content = replace(post_content, 'Ε', 'Ε');
update wp_posts set post_content = replace(post_content, 'Ζ', 'Ζ');
update wp_posts set post_content = replace(post_content, 'Η', 'Η');
update wp_posts set post_content = replace(post_content, 'Θ', 'Θ');
update wp_posts set post_content = replace(post_content, 'Ι', 'Ι');
update wp_posts set post_content = replace(post_content, 'Κ', 'Κ');
update wp_posts set post_content = replace(post_content, 'Λ', 'Λ');
update wp_posts set post_content = replace(post_content, 'Îœ', 'Μ');
update wp_posts set post_content = replace(post_content, 'Ν', 'Ν');
update wp_posts set post_content = replace(post_content, 'Ξ', 'Ξ');
update wp_posts set post_content = replace(post_content, 'Ο', 'Ο');
update wp_posts set post_content = replace(post_content, 'Π', 'Π');
update wp_posts set post_content = replace(post_content, 'Ρ', 'Ρ');
update wp_posts set post_content = replace(post_content, 'Σ', 'Σ');
update wp_posts set post_content = replace(post_content, 'Τ', 'Τ');
update wp_posts set post_content = replace(post_content, 'Î¥', 'Υ');
update wp_posts set post_content = replace(post_content, 'Φ', 'Φ');
update wp_posts set post_content = replace(post_content, 'Χ', 'Χ');
update wp_posts set post_content = replace(post_content, 'Ψ', 'Ψ');
update wp_posts set post_content = replace(post_content, 'Ω', 'Ω');
update wp_posts set post_content = replace(post_content, 'ά', 'ά');
update wp_posts set post_content = replace(post_content, 'έ', 'έ');
update wp_posts set post_content = replace(post_content, 'ή', 'ή');
update wp_posts set post_content = replace(post_content, 'ί', 'ί');
update wp_posts set post_content = replace(post_content, 'ÏŒ', 'ό');
update wp_posts set post_content = replace(post_content, 'ύ', 'ύ');
update wp_posts set post_content = replace(post_content, 'ÏŽ', 'ώ');
update wp_posts set post_content = replace(post_content, 'Ά', 'Ά');
update wp_posts set post_content = replace(post_content, 'Έ', 'Έ');
update wp_posts set post_content = replace(post_content, 'Ή', 'Ή');
update wp_posts set post_content = replace(post_content, 'Ί', 'Ί');
update wp_posts set post_content = replace(post_content, 'ÎŒ', 'Ό');
update wp_posts set post_content = replace(post_content, 'ÎŽ', 'Ύ');
update wp_posts set post_content = replace(post_content, 'Ώ', 'Ώ');
update wp_posts set post_content = replace(post_content, 'Ï‹', 'ϋ');
update wp_posts set post_content = replace(post_content, 'ΰ', 'υ');
update wp_posts set post_content = replace(post_content, 'ÏŠ', 'ϊ');
update wp_posts set post_content = replace(post_content, 'ΐ', 'ι');
update wp_posts set post_content = replace(post_content, 'Ï‚', 'ς');
update wp_posts set post_content = replace(post_content, '…', '…');
update wp_posts set post_content = replace(post_content, '’', '’');
update wp_posts set post_content = replace(post_content, 'àƒâ‚¬', 'ä');
update wp_posts set post_content = replace(post_content, '‘', '');
update wp_posts set post_content = replace(post_content, '“', '“');
update wp_posts set post_content = replace(post_content, 'â€�', '”');
update wp_posts set post_content = replace(post_content, '‹', '‹');
update wp_posts set post_content = replace(post_content, '›', '›');
update wp_posts set post_content = replace(post_content, '—', '—');
update wp_posts set post_content = replace(post_content, '–', '—');
update wp_posts set post_content = replace(post_content, 'â€?', '”');
update wp_posts set post_content = replace(post_content, 'àƒ’', 'à');
update wp_posts set post_content = replace(post_content, 'â’€’™', '’');
update wp_posts set post_content = replace(post_content, 'â’€’œ', '“');
update wp_posts set post_content = replace(post_content, 'â’€?', '”');
update wp_posts set post_content = replace(post_content, 'àƒ’©', 'é');
update wp_posts set post_content = replace(post_content, 'â’€’¦', '');
update wp_posts set post_content = replace(post_content, '–', '\•');
update wp_posts set post_content = replace(post_content, '€', '€');
update wp_posts set post_content = replace(post_content, 'â€', '"');
update wp_posts set post_content = replace(post_content, '–', '–');
update wp_posts set post_content = replace(post_content, '•', '-');
update wp_posts set post_content = replace(post_content, '“', '"');
update wp_posts set post_content = replace(post_content, '¡', '¡');
update wp_posts set post_content = replace(post_content, '¢', '¢');
update wp_posts set post_content = replace(post_content, '£', '£');
update wp_posts set post_content = replace(post_content, '¤', '¤');
update wp_posts set post_content = replace(post_content, 'Â¥', '¥');
update wp_posts set post_content = replace(post_content, '¦', '¦');
update wp_posts set post_content = replace(post_content, '§', '§');
update wp_posts set post_content = replace(post_content, '¨', '¨');
update wp_posts set post_content = replace(post_content, '©', '©');
update wp_posts set post_content = replace(post_content, 'ª', 'ª');
update wp_posts set post_content = replace(post_content, '«', '«');
update wp_posts set post_content = replace(post_content, '¬', '¬');
update wp_posts set post_content = replace(post_content, '­', '­');
update wp_posts set post_content = replace(post_content, '®', '®');
update wp_posts set post_content = replace(post_content, '¯', '¯');
update wp_posts set post_content = replace(post_content, '°', '°');
update wp_posts set post_content = replace(post_content, '±', '±');
update wp_posts set post_content = replace(post_content, '²', '²');
update wp_posts set post_content = replace(post_content, '³', '³');
update wp_posts set post_content = replace(post_content, '´', '´');
update wp_posts set post_content = replace(post_content, 'µ', 'µ');
update wp_posts set post_content = replace(post_content, '¶', '¶');
update wp_posts set post_content = replace(post_content, '·', '·');
update wp_posts set post_content = replace(post_content, '¸', '¸');
update wp_posts set post_content = replace(post_content, '¹', '¹');
update wp_posts set post_content = replace(post_content, 'º', 'º');
update wp_posts set post_content = replace(post_content, '»', '»');
update wp_posts set post_content = replace(post_content, '¼', '¼');
update wp_posts set post_content = replace(post_content, '½', '½');
update wp_posts set post_content = replace(post_content, '¾', '¾');
update wp_posts set post_content = replace(post_content, '¿', '¿');
update wp_posts set post_content = replace(post_content, 'À', 'À');
update wp_posts set post_content = replace(post_content, 'Ã', 'Á');
update wp_posts set post_content = replace(post_content, 'Â', 'Â');
update wp_posts set post_content = replace(post_content, 'Ã', 'Ã');
update wp_posts set post_content = replace(post_content, 'Ä', 'Ä');
update wp_posts set post_content = replace(post_content, 'Ã…', 'Å');
update wp_posts set post_content = replace(post_content, 'Æ', 'Æ');
update wp_posts set post_content = replace(post_content, 'Ç', 'Ç');
update wp_posts set post_content = replace(post_content, 'È', 'È');
update wp_posts set post_content = replace(post_content, 'É', 'É');
update wp_posts set post_content = replace(post_content, 'Ê', 'Ê');
update wp_posts set post_content = replace(post_content, 'Ë', 'Ë');
update wp_posts set post_content = replace(post_content, 'ÃŒ', 'Ì');
update wp_posts set post_content = replace(post_content, 'Ã', 'Í');
update wp_posts set post_content = replace(post_content, 'ÃŽ', 'Î');
update wp_posts set post_content = replace(post_content, 'Ã', 'Ï');
update wp_posts set post_content = replace(post_content, 'Ã', 'Ð');
update wp_posts set post_content = replace(post_content, 'Ñ', 'Ñ');
update wp_posts set post_content = replace(post_content, 'Ã’', 'Ò');
update wp_posts set post_content = replace(post_content, 'Ó', 'Ó');
update wp_posts set post_content = replace(post_content, 'Ô', 'Ô');
update wp_posts set post_content = replace(post_content, 'Õ', 'Õ');
update wp_posts set post_content = replace(post_content, 'Ö', 'Ö');
update wp_posts set post_content = replace(post_content, '×', '×');
update wp_posts set post_content = replace(post_content, 'Ø', 'Ø');
update wp_posts set post_content = replace(post_content, 'Ù', 'Ù');
update wp_posts set post_content = replace(post_content, 'Ú', 'Ú');
update wp_posts set post_content = replace(post_content, 'Û', 'Û');
update wp_posts set post_content = replace(post_content, 'Ãœ', 'Ü');
update wp_posts set post_content = replace(post_content, 'Ã', 'Ý');
update wp_posts set post_content = replace(post_content, 'Þ', 'Þ');
update wp_posts set post_content = replace(post_content, 'ß', 'ß');
update wp_posts set post_content = replace(post_content, 'Ã ', 'à');
update wp_posts set post_content = replace(post_content, 'á', 'á');
update wp_posts set post_content = replace(post_content, 'â', 'â');
update wp_posts set post_content = replace(post_content, 'ã', 'ã');
update wp_posts set post_content = replace(post_content, 'ä', 'ä');
update wp_posts set post_content = replace(post_content, 'Ã¥', 'å');
update wp_posts set post_content = replace(post_content, 'æ', 'æ');
update wp_posts set post_content = replace(post_content, 'ç', 'ç');
update wp_posts set post_content = replace(post_content, 'è', 'è');
update wp_posts set post_content = replace(post_content, 'é', 'é');
update wp_posts set post_content = replace(post_content, 'ê', 'ê');
update wp_posts set post_content = replace(post_content, 'ë', 'ë');
update wp_posts set post_content = replace(post_content, 'ì', 'ì');
update wp_posts set post_content = replace(post_content, '­­Ã', 'í');
update wp_posts set post_content = replace(post_content, 'î', 'î');
update wp_posts set post_content = replace(post_content, 'ï', 'ï');
update wp_posts set post_content = replace(post_content, 'ð', 'ð');
update wp_posts set post_content = replace(post_content, 'ñ', 'ñ');
update wp_posts set post_content = replace(post_content, 'ò', 'ò');
update wp_posts set post_content = replace(post_content, 'ó', 'ó');
update wp_posts set post_content = replace(post_content, 'ô', 'ô');
update wp_posts set post_content = replace(post_content, 'õ', 'õ');
update wp_posts set post_content = replace(post_content, 'ö', 'ö');
update wp_posts set post_content = replace(post_content, '÷', '÷');
update wp_posts set post_content = replace(post_content, 'ø', 'ø');
update wp_posts set post_content = replace(post_content, 'ù', 'ù');
update wp_posts set post_content = replace(post_content, 'ú', 'ú');
update wp_posts set post_content = replace(post_content, 'û', 'û');
update wp_posts set post_content = replace(post_content, 'ü', 'ü');
update wp_posts set post_content = replace(post_content, 'ý', 'ý');
update wp_posts set post_content = replace(post_content, 'þ', 'þ');
update wp_posts set post_content = replace(post_content, 'ÿ', 'ÿ');
update wp_posts set post_excerpt = replace(post_excerpt, 'α', 'α');
update wp_posts set post_excerpt = replace(post_excerpt, 'β', 'β');
update wp_posts set post_excerpt = replace(post_excerpt, 'γ', 'γ');
update wp_posts set post_excerpt = replace(post_excerpt, 'δ', 'δ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ε', 'ε');
update wp_posts set post_excerpt = replace(post_excerpt, 'ζ', 'ζ');
update wp_posts set post_excerpt = replace(post_excerpt, 'η', 'η');
update wp_posts set post_excerpt = replace(post_excerpt, 'θ', 'θ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ι', 'ι');
update wp_posts set post_excerpt = replace(post_excerpt, 'κ', 'κ');
update wp_posts set post_excerpt = replace(post_excerpt, 'λ', 'λ');
update wp_posts set post_excerpt = replace(post_excerpt, 'μ', 'μ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ν', 'ν');
update wp_posts set post_excerpt = replace(post_excerpt, 'ξ', 'ξ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ο', 'ο');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï€', 'π');
update wp_posts set post_excerpt = replace(post_excerpt, 'ρ', 'ρ');
update wp_posts set post_excerpt = replace(post_excerpt, 'σ', 'σ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï„', 'τ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï…', 'υ');
update wp_posts set post_excerpt = replace(post_excerpt, 'φ', 'φ');
update wp_posts set post_excerpt = replace(post_excerpt, 'χ', 'χ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ψ', 'ψ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ω', 'ω');
update wp_posts set post_excerpt = replace(post_excerpt, 'Α', 'Α');
update wp_posts set post_excerpt = replace(post_excerpt, 'Î’', 'Β');
update wp_posts set post_excerpt = replace(post_excerpt, 'Γ', 'Γ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Δ', 'Δ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ε', 'Ε');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ζ', 'Ζ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Η', 'Η');
update wp_posts set post_excerpt = replace(post_excerpt, 'Θ', 'Θ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ι', 'Ι');
update wp_posts set post_excerpt = replace(post_excerpt, 'Κ', 'Κ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Λ', 'Λ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Îœ', 'Μ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ν', 'Ν');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ξ', 'Ξ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ο', 'Ο');
update wp_posts set post_excerpt = replace(post_excerpt, 'Π', 'Π');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ρ', 'Ρ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Σ', 'Σ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Τ', 'Τ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Î¥', 'Υ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Φ', 'Φ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Χ', 'Χ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ψ', 'Ψ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ω', 'Ω');
update wp_posts set post_excerpt = replace(post_excerpt, 'ά', 'ά');
update wp_posts set post_excerpt = replace(post_excerpt, 'έ', 'έ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ή', 'ή');
update wp_posts set post_excerpt = replace(post_excerpt, 'ί', 'ί');
update wp_posts set post_excerpt = replace(post_excerpt, 'ÏŒ', 'ό');
update wp_posts set post_excerpt = replace(post_excerpt, 'ύ', 'ύ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ÏŽ', 'ώ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ά', 'Ά');
update wp_posts set post_excerpt = replace(post_excerpt, 'Έ', 'Έ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ή', 'Ή');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ί', 'Ί');
update wp_posts set post_excerpt = replace(post_excerpt, 'ÎŒ', 'Ό');
update wp_posts set post_excerpt = replace(post_excerpt, 'ÎŽ', 'Ύ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ώ', 'Ώ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï‹', 'ϋ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ΰ', 'υ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ÏŠ', 'ϊ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ΐ', 'ι');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï‚', 'ς');
update wp_posts set post_excerpt = replace(post_excerpt, '…', '…');
update wp_posts set post_excerpt = replace(post_excerpt, '’', '’');
update wp_posts set post_excerpt = replace(post_excerpt, 'àƒâ‚¬', 'ä');
update wp_posts set post_excerpt = replace(post_excerpt, '‘', '');
update wp_posts set post_excerpt = replace(post_excerpt, '“', '“');
update wp_posts set post_excerpt = replace(post_excerpt, 'â€�', '”');
update wp_posts set post_excerpt = replace(post_excerpt, '‹', '‹');
update wp_posts set post_excerpt = replace(post_excerpt, '›', '›');
update wp_posts set post_excerpt = replace(post_excerpt, '—', '—');
update wp_posts set post_excerpt = replace(post_excerpt, '–', '—');
update wp_posts set post_excerpt = replace(post_excerpt, 'â€?', '”');
update wp_posts set post_excerpt = replace(post_excerpt, 'àƒ’', 'à');
update wp_posts set post_excerpt = replace(post_excerpt, 'â’€’™', '’');
update wp_posts set post_excerpt = replace(post_excerpt, 'â’€’œ', '“');
update wp_posts set post_excerpt = replace(post_excerpt, 'â’€?', '”');
update wp_posts set post_excerpt = replace(post_excerpt, 'àƒ’©', 'é');
update wp_posts set post_excerpt = replace(post_excerpt, 'â’€’¦', '');
update wp_posts set post_excerpt = replace(post_excerpt, '–', '\•');
update wp_posts set post_excerpt = replace(post_excerpt, '€', '€');
update wp_posts set post_excerpt = replace(post_excerpt, 'â€', '"');
update wp_posts set post_excerpt = replace(post_excerpt, '–', '–');
update wp_posts set post_excerpt = replace(post_excerpt, '•', '-');
update wp_posts set post_excerpt = replace(post_excerpt, '“', '"');
update wp_posts set post_excerpt = replace(post_excerpt, '¡', '¡');
update wp_posts set post_excerpt = replace(post_excerpt, '¢', '¢');
update wp_posts set post_excerpt = replace(post_excerpt, '£', '£');
update wp_posts set post_excerpt = replace(post_excerpt, '¤', '¤');
update wp_posts set post_excerpt = replace(post_excerpt, 'Â¥', '¥');
update wp_posts set post_excerpt = replace(post_excerpt, '¦', '¦');
update wp_posts set post_excerpt = replace(post_excerpt, '§', '§');
update wp_posts set post_excerpt = replace(post_excerpt, '¨', '¨');
update wp_posts set post_excerpt = replace(post_excerpt, '©', '©');
update wp_posts set post_excerpt = replace(post_excerpt, 'ª', 'ª');
update wp_posts set post_excerpt = replace(post_excerpt, '«', '«');
update wp_posts set post_excerpt = replace(post_excerpt, '¬', '¬');
update wp_posts set post_excerpt = replace(post_excerpt, '­', '­');
update wp_posts set post_excerpt = replace(post_excerpt, '®', '®');
update wp_posts set post_excerpt = replace(post_excerpt, '¯', '¯');
update wp_posts set post_excerpt = replace(post_excerpt, '°', '°');
update wp_posts set post_excerpt = replace(post_excerpt, '±', '±');
update wp_posts set post_excerpt = replace(post_excerpt, '²', '²');
update wp_posts set post_excerpt = replace(post_excerpt, '³', '³');
update wp_posts set post_excerpt = replace(post_excerpt, '´', '´');
update wp_posts set post_excerpt = replace(post_excerpt, 'µ', 'µ');
update wp_posts set post_excerpt = replace(post_excerpt, '¶', '¶');
update wp_posts set post_excerpt = replace(post_excerpt, '·', '·');
update wp_posts set post_excerpt = replace(post_excerpt, '¸', '¸');
update wp_posts set post_excerpt = replace(post_excerpt, '¹', '¹');
update wp_posts set post_excerpt = replace(post_excerpt, 'º', 'º');
update wp_posts set post_excerpt = replace(post_excerpt, '»', '»');
update wp_posts set post_excerpt = replace(post_excerpt, '¼', '¼');
update wp_posts set post_excerpt = replace(post_excerpt, '½', '½');
update wp_posts set post_excerpt = replace(post_excerpt, '¾', '¾');
update wp_posts set post_excerpt = replace(post_excerpt, '¿', '¿');
update wp_posts set post_excerpt = replace(post_excerpt, 'À', 'À');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Á');
update wp_posts set post_excerpt = replace(post_excerpt, 'Â', 'Â');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Ã');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ä', 'Ä');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã…', 'Å');
update wp_posts set post_excerpt = replace(post_excerpt, 'Æ', 'Æ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ç', 'Ç');
update wp_posts set post_excerpt = replace(post_excerpt, 'È', 'È');
update wp_posts set post_excerpt = replace(post_excerpt, 'É', 'É');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ê', 'Ê');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ë', 'Ë');
update wp_posts set post_excerpt = replace(post_excerpt, 'ÃŒ', 'Ì');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Í');
update wp_posts set post_excerpt = replace(post_excerpt, 'ÃŽ', 'Î');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Ï');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Ð');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ñ', 'Ñ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã’', 'Ò');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ó', 'Ó');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ô', 'Ô');
update wp_posts set post_excerpt = replace(post_excerpt, 'Õ', 'Õ');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ö', 'Ö');
update wp_posts set post_excerpt = replace(post_excerpt, '×', '×');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ø', 'Ø');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ù', 'Ù');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ú', 'Ú');
update wp_posts set post_excerpt = replace(post_excerpt, 'Û', 'Û');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ãœ', 'Ü');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Ý');
update wp_posts set post_excerpt = replace(post_excerpt, 'Þ', 'Þ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ß', 'ß');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã ', 'à');
update wp_posts set post_excerpt = replace(post_excerpt, 'á', 'á');
update wp_posts set post_excerpt = replace(post_excerpt, 'â', 'â');
update wp_posts set post_excerpt = replace(post_excerpt, 'ã', 'ã');
update wp_posts set post_excerpt = replace(post_excerpt, 'ä', 'ä');
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã¥', 'å');
update wp_posts set post_excerpt = replace(post_excerpt, 'æ', 'æ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ç', 'ç');
update wp_posts set post_excerpt = replace(post_excerpt, 'è', 'è');
update wp_posts set post_excerpt = replace(post_excerpt, 'é', 'é');
update wp_posts set post_excerpt = replace(post_excerpt, 'ê', 'ê');
update wp_posts set post_excerpt = replace(post_excerpt, 'ë', 'ë');
update wp_posts set post_excerpt = replace(post_excerpt, 'ì', 'ì');
update wp_posts set post_excerpt = replace(post_excerpt, '­­Ã', 'í');
update wp_posts set post_excerpt = replace(post_excerpt, 'î', 'î');
update wp_posts set post_excerpt = replace(post_excerpt, 'ï', 'ï');
update wp_posts set post_excerpt = replace(post_excerpt, 'ð', 'ð');
update wp_posts set post_excerpt = replace(post_excerpt, 'ñ', 'ñ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ò', 'ò');
update wp_posts set post_excerpt = replace(post_excerpt, 'ó', 'ó');
update wp_posts set post_excerpt = replace(post_excerpt, 'ô', 'ô');
update wp_posts set post_excerpt = replace(post_excerpt, 'õ', 'õ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ö', 'ö');
update wp_posts set post_excerpt = replace(post_excerpt, '÷', '÷');
update wp_posts set post_excerpt = replace(post_excerpt, 'ø', 'ø');
update wp_posts set post_excerpt = replace(post_excerpt, 'ù', 'ù');
update wp_posts set post_excerpt = replace(post_excerpt, 'ú', 'ú');
update wp_posts set post_excerpt = replace(post_excerpt, 'û', 'û');
update wp_posts set post_excerpt = replace(post_excerpt, 'ü', 'ü');
update wp_posts set post_excerpt = replace(post_excerpt, 'ý', 'ý');
update wp_posts set post_excerpt = replace(post_excerpt, 'þ', 'þ');
update wp_posts set post_excerpt = replace(post_excerpt, 'ÿ', 'ÿ');
update wp_posts set post_title = replace(post_title, 'α', 'α');
update wp_posts set post_title = replace(post_title, 'β', 'β');
update wp_posts set post_title = replace(post_title, 'γ', 'γ');
update wp_posts set post_title = replace(post_title, 'δ', 'δ');
update wp_posts set post_title = replace(post_title, 'ε', 'ε');
update wp_posts set post_title = replace(post_title, 'ζ', 'ζ');
update wp_posts set post_title = replace(post_title, 'η', 'η');
update wp_posts set post_title = replace(post_title, 'θ', 'θ');
update wp_posts set post_title = replace(post_title, 'ι', 'ι');
update wp_posts set post_title = replace(post_title, 'κ', 'κ');
update wp_posts set post_title = replace(post_title, 'λ', 'λ');
update wp_posts set post_title = replace(post_title, 'μ', 'μ');
update wp_posts set post_title = replace(post_title, 'ν', 'ν');
update wp_posts set post_title = replace(post_title, 'ξ', 'ξ');
update wp_posts set post_title = replace(post_title, 'ο', 'ο');
update wp_posts set post_title = replace(post_title, 'Ï€', 'π');
update wp_posts set post_title = replace(post_title, 'ρ', 'ρ');
update wp_posts set post_title = replace(post_title, 'σ', 'σ');
update wp_posts set post_title = replace(post_title, 'Ï„', 'τ');
update wp_posts set post_title = replace(post_title, 'Ï…', 'υ');
update wp_posts set post_title = replace(post_title, 'φ', 'φ');
update wp_posts set post_title = replace(post_title, 'χ', 'χ');
update wp_posts set post_title = replace(post_title, 'ψ', 'ψ');
update wp_posts set post_title = replace(post_title, 'ω', 'ω');
update wp_posts set post_title = replace(post_title, 'Α', 'Α');
update wp_posts set post_title = replace(post_title, 'Î’', 'Β');
update wp_posts set post_title = replace(post_title, 'Γ', 'Γ');
update wp_posts set post_title = replace(post_title, 'Δ', 'Δ');
update wp_posts set post_title = replace(post_title, 'Ε', 'Ε');
update wp_posts set post_title = replace(post_title, 'Ζ', 'Ζ');
update wp_posts set post_title = replace(post_title, 'Η', 'Η');
update wp_posts set post_title = replace(post_title, 'Θ', 'Θ');
update wp_posts set post_title = replace(post_title, 'Ι', 'Ι');
update wp_posts set post_title = replace(post_title, 'Κ', 'Κ');
update wp_posts set post_title = replace(post_title, 'Λ', 'Λ');
update wp_posts set post_title = replace(post_title, 'Îœ', 'Μ');
update wp_posts set post_title = replace(post_title, 'Ν', 'Ν');
update wp_posts set post_title = replace(post_title, 'Ξ', 'Ξ');
update wp_posts set post_title = replace(post_title, 'Ο', 'Ο');
update wp_posts set post_title = replace(post_title, 'Π', 'Π');
update wp_posts set post_title = replace(post_title, 'Ρ', 'Ρ');
update wp_posts set post_title = replace(post_title, 'Σ', 'Σ');
update wp_posts set post_title = replace(post_title, 'Τ', 'Τ');
update wp_posts set post_title = replace(post_title, 'Î¥', 'Υ');
update wp_posts set post_title = replace(post_title, 'Φ', 'Φ');
update wp_posts set post_title = replace(post_title, 'Χ', 'Χ');
update wp_posts set post_title = replace(post_title, 'Ψ', 'Ψ');
update wp_posts set post_title = replace(post_title, 'Ω', 'Ω');
update wp_posts set post_title = replace(post_title, 'ά', 'ά');
update wp_posts set post_title = replace(post_title, 'έ', 'έ');
update wp_posts set post_title = replace(post_title, 'ή', 'ή');
update wp_posts set post_title = replace(post_title, 'ί', 'ί');
update wp_posts set post_title = replace(post_title, 'ÏŒ', 'ό');
update wp_posts set post_title = replace(post_title, 'ύ', 'ύ');
update wp_posts set post_title = replace(post_title, 'ÏŽ', 'ώ');
update wp_posts set post_title = replace(post_title, 'Ά', 'Ά');
update wp_posts set post_title = replace(post_title, 'Έ', 'Έ');
update wp_posts set post_title = replace(post_title, 'Ή', 'Ή');
update wp_posts set post_title = replace(post_title, 'Ί', 'Ί');
update wp_posts set post_title = replace(post_title, 'ÎŒ', 'Ό');
update wp_posts set post_title = replace(post_title, 'ÎŽ', 'Ύ');
update wp_posts set post_title = replace(post_title, 'Ώ', 'Ώ');
update wp_posts set post_title = replace(post_title, 'Ï‹', 'ϋ');
update wp_posts set post_title = replace(post_title, 'ΰ', 'υ');
update wp_posts set post_title = replace(post_title, 'ÏŠ', 'ϊ');
update wp_posts set post_title = replace(post_title, 'ΐ', 'ι');
update wp_posts set post_title = replace(post_title, 'Ï‚', 'ς');
update wp_posts set post_title = replace(post_title, '…', '…');
update wp_posts set post_title = replace(post_title, '’', '’');
update wp_posts set post_title = replace(post_title, 'àƒâ‚¬', 'ä');
update wp_posts set post_title = replace(post_title, '‘', '');
update wp_posts set post_title = replace(post_title, '“', '“');
update wp_posts set post_title = replace(post_title, 'â€�', '”');
update wp_posts set post_title = replace(post_title, '‹', '‹');
update wp_posts set post_title = replace(post_title, '›', '›');
update wp_posts set post_title = replace(post_title, '—', '—');
update wp_posts set post_title = replace(post_title, '–', '—');
update wp_posts set post_title = replace(post_title, 'â€?', '”');
update wp_posts set post_title = replace(post_title, 'àƒ’', 'à');
update wp_posts set post_title = replace(post_title, 'â’€’™', '’');
update wp_posts set post_title = replace(post_title, 'â’€’œ', '“');
update wp_posts set post_title = replace(post_title, 'â’€?', '”');
update wp_posts set post_title = replace(post_title, 'àƒ’©', 'é');
update wp_posts set post_title = replace(post_title, 'â’€’¦', '');
update wp_posts set post_title = replace(post_title, '–', '\•');
update wp_posts set post_title = replace(post_title, '€', '€');
update wp_posts set post_title = replace(post_title, 'â€', '"');
update wp_posts set post_title = replace(post_title, '–', '–');
update wp_posts set post_title = replace(post_title, '•', '-');
update wp_posts set post_title = replace(post_title, '“', '"');
update wp_posts set post_title = replace(post_title, '¡', '¡');
update wp_posts set post_title = replace(post_title, '¢', '¢');
update wp_posts set post_title = replace(post_title, '£', '£');
update wp_posts set post_title = replace(post_title, '¤', '¤');
update wp_posts set post_title = replace(post_title, 'Â¥', '¥');
update wp_posts set post_title = replace(post_title, '¦', '¦');
update wp_posts set post_title = replace(post_title, '§', '§');
update wp_posts set post_title = replace(post_title, '¨', '¨');
update wp_posts set post_title = replace(post_title, '©', '©');
update wp_posts set post_title = replace(post_title, 'ª', 'ª');
update wp_posts set post_title = replace(post_title, '«', '«');
update wp_posts set post_title = replace(post_title, '¬', '¬');
update wp_posts set post_title = replace(post_title, '­', '­');
update wp_posts set post_title = replace(post_title, '®', '®');
update wp_posts set post_title = replace(post_title, '¯', '¯');
update wp_posts set post_title = replace(post_title, '°', '°');
update wp_posts set post_title = replace(post_title, '±', '±');
update wp_posts set post_title = replace(post_title, '²', '²');
update wp_posts set post_title = replace(post_title, '³', '³');
update wp_posts set post_title = replace(post_title, '´', '´');
update wp_posts set post_title = replace(post_title, 'µ', 'µ');
update wp_posts set post_title = replace(post_title, '¶', '¶');
update wp_posts set post_title = replace(post_title, '·', '·');
update wp_posts set post_title = replace(post_title, '¸', '¸');
update wp_posts set post_title = replace(post_title, '¹', '¹');
update wp_posts set post_title = replace(post_title, 'º', 'º');
update wp_posts set post_title = replace(post_title, '»', '»');
update wp_posts set post_title = replace(post_title, '¼', '¼');
update wp_posts set post_title = replace(post_title, '½', '½');
update wp_posts set post_title = replace(post_title, '¾', '¾');
update wp_posts set post_title = replace(post_title, '¿', '¿');
update wp_posts set post_title = replace(post_title, 'À', 'À');
update wp_posts set post_title = replace(post_title, 'Ã', 'Á');
update wp_posts set post_title = replace(post_title, 'Â', 'Â');
update wp_posts set post_title = replace(post_title, 'Ã', 'Ã');
update wp_posts set post_title = replace(post_title, 'Ä', 'Ä');
update wp_posts set post_title = replace(post_title, 'Ã…', 'Å');
update wp_posts set post_title = replace(post_title, 'Æ', 'Æ');
update wp_posts set post_title = replace(post_title, 'Ç', 'Ç');
update wp_posts set post_title = replace(post_title, 'È', 'È');
update wp_posts set post_title = replace(post_title, 'É', 'É');
update wp_posts set post_title = replace(post_title, 'Ê', 'Ê');
update wp_posts set post_title = replace(post_title, 'Ë', 'Ë');
update wp_posts set post_title = replace(post_title, 'ÃŒ', 'Ì');
update wp_posts set post_title = replace(post_title, 'Ã', 'Í');
update wp_posts set post_title = replace(post_title, 'ÃŽ', 'Î');
update wp_posts set post_title = replace(post_title, 'Ã', 'Ï');
update wp_posts set post_title = replace(post_title, 'Ã', 'Ð');
update wp_posts set post_title = replace(post_title, 'Ñ', 'Ñ');
update wp_posts set post_title = replace(post_title, 'Ã’', 'Ò');
update wp_posts set post_title = replace(post_title, 'Ó', 'Ó');
update wp_posts set post_title = replace(post_title, 'Ô', 'Ô');
update wp_posts set post_title = replace(post_title, 'Õ', 'Õ');
update wp_posts set post_title = replace(post_title, 'Ö', 'Ö');
update wp_posts set post_title = replace(post_title, '×', '×');
update wp_posts set post_title = replace(post_title, 'Ø', 'Ø');
update wp_posts set post_title = replace(post_title, 'Ù', 'Ù');
update wp_posts set post_title = replace(post_title, 'Ú', 'Ú');
update wp_posts set post_title = replace(post_title, 'Û', 'Û');
update wp_posts set post_title = replace(post_title, 'Ãœ', 'Ü');
update wp_posts set post_title = replace(post_title, 'Ã', 'Ý');
update wp_posts set post_title = replace(post_title, 'Þ', 'Þ');
update wp_posts set post_title = replace(post_title, 'ß', 'ß');
update wp_posts set post_title = replace(post_title, 'Ã ', 'à');
update wp_posts set post_title = replace(post_title, 'á', 'á');
update wp_posts set post_title = replace(post_title, 'â', 'â');
update wp_posts set post_title = replace(post_title, 'ã', 'ã');
update wp_posts set post_title = replace(post_title, 'ä', 'ä');
update wp_posts set post_title = replace(post_title, 'Ã¥', 'å');
update wp_posts set post_title = replace(post_title, 'æ', 'æ');
update wp_posts set post_title = replace(post_title, 'ç', 'ç');
update wp_posts set post_title = replace(post_title, 'è', 'è');
update wp_posts set post_title = replace(post_title, 'é', 'é');
update wp_posts set post_title = replace(post_title, 'ê', 'ê');
update wp_posts set post_title = replace(post_title, 'ë', 'ë');
update wp_posts set post_title = replace(post_title, 'ì', 'ì');
update wp_posts set post_title = replace(post_title, '­­Ã', 'í');
update wp_posts set post_title = replace(post_title, 'î', 'î');
update wp_posts set post_title = replace(post_title, 'ï', 'ï');
update wp_posts set post_title = replace(post_title, 'ð', 'ð');
update wp_posts set post_title = replace(post_title, 'ñ', 'ñ');
update wp_posts set post_title = replace(post_title, 'ò', 'ò');
update wp_posts set post_title = replace(post_title, 'ó', 'ó');
update wp_posts set post_title = replace(post_title, 'ô', 'ô');
update wp_posts set post_title = replace(post_title, 'õ', 'õ');
update wp_posts set post_title = replace(post_title, 'ö', 'ö');
update wp_posts set post_title = replace(post_title, '÷', '÷');
update wp_posts set post_title = replace(post_title, 'ø', 'ø');
update wp_posts set post_title = replace(post_title, 'ù', 'ù');
update wp_posts set post_title = replace(post_title, 'ú', 'ú');
update wp_posts set post_title = replace(post_title, 'û', 'û');
update wp_posts set post_title = replace(post_title, 'ü', 'ü');
update wp_posts set post_title = replace(post_title, 'ý', 'ý');
update wp_posts set post_title = replace(post_title, 'þ', 'þ');
update wp_posts set post_title = replace(post_title, 'ÿ', 'ÿ');
update wp_terms set name = replace(name, 'α', 'α');
update wp_terms set name = replace(name, 'β', 'β');
update wp_terms set name = replace(name, 'γ', 'γ');
update wp_terms set name = replace(name, 'δ', 'δ');
update wp_terms set name = replace(name, 'ε', 'ε');
update wp_terms set name = replace(name, 'ζ', 'ζ');
update wp_terms set name = replace(name, 'η', 'η');
update wp_terms set name = replace(name, 'θ', 'θ');
update wp_terms set name = replace(name, 'ι', 'ι');
update wp_terms set name = replace(name, 'κ', 'κ');
update wp_terms set name = replace(name, 'λ', 'λ');
update wp_terms set name = replace(name, 'μ', 'μ');
update wp_terms set name = replace(name, 'ν', 'ν');
update wp_terms set name = replace(name, 'ξ', 'ξ');
update wp_terms set name = replace(name, 'ο', 'ο');
update wp_terms set name = replace(name, 'Ï€', 'π');
update wp_terms set name = replace(name, 'ρ', 'ρ');
update wp_terms set name = replace(name, 'σ', 'σ');
update wp_terms set name = replace(name, 'Ï„', 'τ');
update wp_terms set name = replace(name, 'Ï…', 'υ');
update wp_terms set name = replace(name, 'φ', 'φ');
update wp_terms set name = replace(name, 'χ', 'χ');
update wp_terms set name = replace(name, 'ψ', 'ψ');
update wp_terms set name = replace(name, 'ω', 'ω');
update wp_terms set name = replace(name, 'Α', 'Α');
update wp_terms set name = replace(name, 'Î’', 'Β');
update wp_terms set name = replace(name, 'Γ', 'Γ');
update wp_terms set name = replace(name, 'Δ', 'Δ');
update wp_terms set name = replace(name, 'Ε', 'Ε');
update wp_terms set name = replace(name, 'Ζ', 'Ζ');
update wp_terms set name = replace(name, 'Η', 'Η');
update wp_terms set name = replace(name, 'Θ', 'Θ');
update wp_terms set name = replace(name, 'Ι', 'Ι');
update wp_terms set name = replace(name, 'Κ', 'Κ');
update wp_terms set name = replace(name, 'Λ', 'Λ');
update wp_terms set name = replace(name, 'Îœ', 'Μ');
update wp_terms set name = replace(name, 'Ν', 'Ν');
update wp_terms set name = replace(name, 'Ξ', 'Ξ');
update wp_terms set name = replace(name, 'Ο', 'Ο');
update wp_terms set name = replace(name, 'Π', 'Π');
update wp_terms set name = replace(name, 'Ρ', 'Ρ');
update wp_terms set name = replace(name, 'Σ', 'Σ');
update wp_terms set name = replace(name, 'Τ', 'Τ');
update wp_terms set name = replace(name, 'Î¥', 'Υ');
update wp_terms set name = replace(name, 'Φ', 'Φ');
update wp_terms set name = replace(name, 'Χ', 'Χ');
update wp_terms set name = replace(name, 'Ψ', 'Ψ');
update wp_terms set name = replace(name, 'Ω', 'Ω');
update wp_terms set name = replace(name, 'ά', 'ά');
update wp_terms set name = replace(name, 'έ', 'έ');
update wp_terms set name = replace(name, 'ή', 'ή');
update wp_terms set name = replace(name, 'ί', 'ί');
update wp_terms set name = replace(name, 'ÏŒ', 'ό');
update wp_terms set name = replace(name, 'ύ', 'ύ');
update wp_terms set name = replace(name, 'ÏŽ', 'ώ');
update wp_terms set name = replace(name, 'Ά', 'Ά');
update wp_terms set name = replace(name, 'Έ', 'Έ');
update wp_terms set name = replace(name, 'Ή', 'Ή');
update wp_terms set name = replace(name, 'Ί', 'Ί');
update wp_terms set name = replace(name, 'ÎŒ', 'Ό');
update wp_terms set name = replace(name, 'ÎŽ', 'Ύ');
update wp_terms set name = replace(name, 'Ώ', 'Ώ');
update wp_terms set name = replace(name, 'Ï‹', 'ϋ');
update wp_terms set name = replace(name, 'ΰ', 'υ');
update wp_terms set name = replace(name, 'ÏŠ', 'ϊ');
update wp_terms set name = replace(name, 'ΐ', 'ι');
update wp_terms set name = replace(name, 'Ï‚', 'ς');
update wp_terms set name = replace(name, '…', '…');
update wp_terms set name = replace(name, '’', '’');
update wp_terms set name = replace(name, 'àƒâ‚¬', 'ä');
update wp_terms set name = replace(name, '‘', '');
update wp_terms set name = replace(name, '“', '“');
update wp_terms set name = replace(name, 'â€�', '”');
update wp_terms set name = replace(name, '‹', '‹');
update wp_terms set name = replace(name, '›', '›');
update wp_terms set name = replace(name, '—', '—');
update wp_terms set name = replace(name, '–', '—');
update wp_terms set name = replace(name, 'â€?', '”');
update wp_terms set name = replace(name, 'àƒ’', 'à');
update wp_terms set name = replace(name, 'â’€’™', '’');
update wp_terms set name = replace(name, 'â’€’œ', '“');
update wp_terms set name = replace(name, 'â’€?', '”');
update wp_terms set name = replace(name, 'àƒ’©', 'é');
update wp_terms set name = replace(name, 'â’€’¦', '');
update wp_terms set name = replace(name, '–', '\•');
update wp_terms set name = replace(name, '€', '€');
update wp_terms set name = replace(name, 'â€', '"');
update wp_terms set name = replace(name, '–', '–');
update wp_terms set name = replace(name, '•', '-');
update wp_terms set name = replace(name, '“', '"');
update wp_terms set name = replace(name, '¡', '¡');
update wp_terms set name = replace(name, '¢', '¢');
update wp_terms set name = replace(name, '£', '£');
update wp_terms set name = replace(name, '¤', '¤');
update wp_terms set name = replace(name, 'Â¥', '¥');
update wp_terms set name = replace(name, '¦', '¦');
update wp_terms set name = replace(name, '§', '§');
update wp_terms set name = replace(name, '¨', '¨');
update wp_terms set name = replace(name, '©', '©');
update wp_terms set name = replace(name, 'ª', 'ª');
update wp_terms set name = replace(name, '«', '«');
update wp_terms set name = replace(name, '¬', '¬');
update wp_terms set name = replace(name, '­', '­');
update wp_terms set name = replace(name, '®', '®');
update wp_terms set name = replace(name, '¯', '¯');
update wp_terms set name = replace(name, '°', '°');
update wp_terms set name = replace(name, '±', '±');
update wp_terms set name = replace(name, '²', '²');
update wp_terms set name = replace(name, '³', '³');
update wp_terms set name = replace(name, '´', '´');
update wp_terms set name = replace(name, 'µ', 'µ');
update wp_terms set name = replace(name, '¶', '¶');
update wp_terms set name = replace(name, '·', '·');
update wp_terms set name = replace(name, '¸', '¸');
update wp_terms set name = replace(name, '¹', '¹');
update wp_terms set name = replace(name, 'º', 'º');
update wp_terms set name = replace(name, '»', '»');
update wp_terms set name = replace(name, '¼', '¼');
update wp_terms set name = replace(name, '½', '½');
update wp_terms set name = replace(name, '¾', '¾');
update wp_terms set name = replace(name, '¿', '¿');
update wp_terms set name = replace(name, 'À', 'À');
update wp_terms set name = replace(name, 'Ã', 'Á');
update wp_terms set name = replace(name, 'Â', 'Â');
update wp_terms set name = replace(name, 'Ã', 'Ã');
update wp_terms set name = replace(name, 'Ä', 'Ä');
update wp_terms set name = replace(name, 'Ã…', 'Å');
update wp_terms set name = replace(name, 'Æ', 'Æ');
update wp_terms set name = replace(name, 'Ç', 'Ç');
update wp_terms set name = replace(name, 'È', 'È');
update wp_terms set name = replace(name, 'É', 'É');
update wp_terms set name = replace(name, 'Ê', 'Ê');
update wp_terms set name = replace(name, 'Ë', 'Ë');
update wp_terms set name = replace(name, 'ÃŒ', 'Ì');
update wp_terms set name = replace(name, 'Ã', 'Í');
update wp_terms set name = replace(name, 'ÃŽ', 'Î');
update wp_terms set name = replace(name, 'Ã', 'Ï');
update wp_terms set name = replace(name, 'Ã', 'Ð');
update wp_terms set name = replace(name, 'Ñ', 'Ñ');
update wp_terms set name = replace(name, 'Ã’', 'Ò');
update wp_terms set name = replace(name, 'Ó', 'Ó');
update wp_terms set name = replace(name, 'Ô', 'Ô');
update wp_terms set name = replace(name, 'Õ', 'Õ');
update wp_terms set name = replace(name, 'Ö', 'Ö');
update wp_terms set name = replace(name, '×', '×');
update wp_terms set name = replace(name, 'Ø', 'Ø');
update wp_terms set name = replace(name, 'Ù', 'Ù');
update wp_terms set name = replace(name, 'Ú', 'Ú');
update wp_terms set name = replace(name, 'Û', 'Û');
update wp_terms set name = replace(name, 'Ãœ', 'Ü');
update wp_terms set name = replace(name, 'Ã', 'Ý');
update wp_terms set name = replace(name, 'Þ', 'Þ');
update wp_terms set name = replace(name, 'ß', 'ß');
update wp_terms set name = replace(name, 'Ã ', 'à');
update wp_terms set name = replace(name, 'á', 'á');
update wp_terms set name = replace(name, 'â', 'â');
update wp_terms set name = replace(name, 'ã', 'ã');
update wp_terms set name = replace(name, 'ä', 'ä');
update wp_terms set name = replace(name, 'Ã¥', 'å');
update wp_terms set name = replace(name, 'æ', 'æ');
update wp_terms set name = replace(name, 'ç', 'ç');
update wp_terms set name = replace(name, 'è', 'è');
update wp_terms set name = replace(name, 'é', 'é');
update wp_terms set name = replace(name, 'ê', 'ê');
update wp_terms set name = replace(name, 'ë', 'ë');
update wp_terms set name = replace(name, 'ì', 'ì');
update wp_terms set name = replace(name, '­­Ã', 'í');
update wp_terms set name = replace(name, 'î', 'î');
update wp_terms set name = replace(name, 'ï', 'ï');
update wp_terms set name = replace(name, 'ð', 'ð');
update wp_terms set name = replace(name, 'ñ', 'ñ');
update wp_terms set name = replace(name, 'ò', 'ò');
update wp_terms set name = replace(name, 'ó', 'ó');
update wp_terms set name = replace(name, 'ô', 'ô');
update wp_terms set name = replace(name, 'õ', 'õ');
update wp_terms set name = replace(name, 'ö', 'ö');
update wp_terms set name = replace(name, '÷', '÷');
update wp_terms set name = replace(name, 'ø', 'ø');
update wp_terms set name = replace(name, 'ù', 'ù');
update wp_terms set name = replace(name, 'ú', 'ú');
update wp_terms set name = replace(name, 'û', 'û');
update wp_terms set name = replace(name, 'ü', 'ü');
update wp_terms set name = replace(name, 'ý', 'ý');
update wp_terms set name = replace(name, 'þ', 'þ');
update wp_terms set name = replace(name, 'ÿ', 'ÿ');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment