Skip to content

Instantly share code, notes, and snippets.

@boogah

boogah/wp_comments_comment_content_fix.sql

Last active September 28, 2021 21:14
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save boogah/d624a4c715ec7e938281623ebf8a5dcf to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save boogah/d624a4c715ec7e938281623ebf8a5dcf to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. boogah revised this gist Sep 28, 2021. 6 changed files with 516 additions and 0 deletions.
    86 changes: 86 additions & 0 deletions wp_comments_comment_content_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,89 @@
    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, '•', '-');
    86 changes: 86 additions & 0 deletions wp_postmeta_meta_value_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,89 @@
    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, '•', '-');
    86 changes: 86 additions & 0 deletions wp_posts_post_content_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,89 @@
    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, '•', '-');
    86 changes: 86 additions & 0 deletions wp_posts_post_excerpt_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,89 @@
    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, '•', '-');
    86 changes: 86 additions & 0 deletions wp_posts_post_title_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,89 @@
    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, '•', '-');
    86 changes: 86 additions & 0 deletions wp_terms_name_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1,89 @@
    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, '•', '-');
  2. boogah created this gist Sep 10, 2021.
    99 changes: 99 additions & 0 deletions wp_comments_comment_content_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,99 @@
    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, 'ÿ', 'ÿ');
    99 changes: 99 additions & 0 deletions wp_postmeta_meta_value_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,99 @@
    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, 'ÿ', 'ÿ');
    99 changes: 99 additions & 0 deletions wp_posts_post_content_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,99 @@
    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, 'ÿ', 'ÿ');
    99 changes: 99 additions & 0 deletions wp_posts_post_excerpt_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,99 @@
    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, 'ÿ', 'ÿ');
    99 changes: 99 additions & 0 deletions wp_posts_post_title_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,99 @@
    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, 'ÿ', 'ÿ');
    99 changes: 99 additions & 0 deletions wp_terms_name_fix.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,99 @@
    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, 'ÿ', 'ÿ');