Last active
September 28, 2021 21:14
-
-
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_`.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
update wp_comments set comment_content = replace(comment_content, 'α', 'α'); | |
update wp_comments set comment_content = replace(comment_content, 'β', 'β'); | |
update wp_comments set comment_content = replace(comment_content, 'γ', 'γ'); | |
update wp_comments set comment_content = replace(comment_content, 'δ', 'δ'); | |
update wp_comments set comment_content = replace(comment_content, 'ε', 'ε'); | |
update wp_comments set comment_content = replace(comment_content, 'ζ', 'ζ'); | |
update wp_comments set comment_content = replace(comment_content, 'η', 'η'); | |
update wp_comments set comment_content = replace(comment_content, 'θ', 'θ'); | |
update wp_comments set comment_content = replace(comment_content, 'ι', 'ι'); | |
update wp_comments set comment_content = replace(comment_content, 'κ', 'κ'); | |
update wp_comments set comment_content = replace(comment_content, 'λ', 'λ'); | |
update wp_comments set comment_content = replace(comment_content, 'μ', 'μ'); | |
update wp_comments set comment_content = replace(comment_content, 'ν', 'ν'); | |
update wp_comments set comment_content = replace(comment_content, 'ξ', 'ξ'); | |
update wp_comments set comment_content = replace(comment_content, 'ο', 'ο'); | |
update wp_comments set comment_content = replace(comment_content, 'Ï€', 'π'); | |
update wp_comments set comment_content = replace(comment_content, 'Ï', 'ρ'); | |
update wp_comments set comment_content = replace(comment_content, 'σ', 'σ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ï„', 'τ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ï…', 'υ'); | |
update wp_comments set comment_content = replace(comment_content, 'φ', 'φ'); | |
update wp_comments set comment_content = replace(comment_content, 'χ', 'χ'); | |
update wp_comments set comment_content = replace(comment_content, 'ψ', 'ψ'); | |
update wp_comments set comment_content = replace(comment_content, 'ω', 'ω'); | |
update wp_comments set comment_content = replace(comment_content, 'Α', 'Α'); | |
update wp_comments set comment_content = replace(comment_content, 'Î’', 'Β'); | |
update wp_comments set comment_content = replace(comment_content, 'Γ', 'Γ'); | |
update wp_comments set comment_content = replace(comment_content, 'Δ', 'Δ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ε', 'Ε'); | |
update wp_comments set comment_content = replace(comment_content, 'Ζ', 'Ζ'); | |
update wp_comments set comment_content = replace(comment_content, 'Η', 'Η'); | |
update wp_comments set comment_content = replace(comment_content, 'Θ', 'Θ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ι', 'Ι'); | |
update wp_comments set comment_content = replace(comment_content, 'Κ', 'Κ'); | |
update wp_comments set comment_content = replace(comment_content, 'Λ', 'Λ'); | |
update wp_comments set comment_content = replace(comment_content, 'Îœ', 'Μ'); | |
update wp_comments set comment_content = replace(comment_content, 'Î', 'Ν'); | |
update wp_comments set comment_content = replace(comment_content, 'Ξ', 'Ξ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ο', 'Ο'); | |
update wp_comments set comment_content = replace(comment_content, 'Î ', 'Π'); | |
update wp_comments set comment_content = replace(comment_content, 'Ρ', 'Ρ'); | |
update wp_comments set comment_content = replace(comment_content, 'Σ', 'Σ'); | |
update wp_comments set comment_content = replace(comment_content, 'Τ', 'Τ'); | |
update wp_comments set comment_content = replace(comment_content, 'Î¥', 'Υ'); | |
update wp_comments set comment_content = replace(comment_content, 'Φ', 'Φ'); | |
update wp_comments set comment_content = replace(comment_content, 'Χ', 'Χ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ψ', 'Ψ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ω', 'Ω'); | |
update wp_comments set comment_content = replace(comment_content, 'ά', 'ά'); | |
update wp_comments set comment_content = replace(comment_content, 'Î', 'έ'); | |
update wp_comments set comment_content = replace(comment_content, 'ή', 'ή'); | |
update wp_comments set comment_content = replace(comment_content, 'ί', 'ί'); | |
update wp_comments set comment_content = replace(comment_content, 'ÏŒ', 'ό'); | |
update wp_comments set comment_content = replace(comment_content, 'Ï', 'ύ'); | |
update wp_comments set comment_content = replace(comment_content, 'ÏŽ', 'ώ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ά', 'Ά'); | |
update wp_comments set comment_content = replace(comment_content, 'Έ', 'Έ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ή', 'Ή'); | |
update wp_comments set comment_content = replace(comment_content, 'Ί', 'Ί'); | |
update wp_comments set comment_content = replace(comment_content, 'ÎŒ', 'Ό'); | |
update wp_comments set comment_content = replace(comment_content, 'ÎŽ', 'Ύ'); | |
update wp_comments set comment_content = replace(comment_content, 'Î', 'Ώ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ï‹', 'ϋ'); | |
update wp_comments set comment_content = replace(comment_content, 'ΰ', 'υ'); | |
update wp_comments set comment_content = replace(comment_content, 'ÏŠ', 'ϊ'); | |
update wp_comments set comment_content = replace(comment_content, 'Î', 'ι'); | |
update wp_comments set comment_content = replace(comment_content, 'Ï‚', 'ς'); | |
update wp_comments set comment_content = replace(comment_content, '…', '…'); | |
update wp_comments set comment_content = replace(comment_content, '’', '’'); | |
update wp_comments set comment_content = replace(comment_content, 'àƒâ‚¬', 'ä'); | |
update wp_comments set comment_content = replace(comment_content, '‘', ''); | |
update wp_comments set comment_content = replace(comment_content, '“', '“'); | |
update wp_comments set comment_content = replace(comment_content, 'â€�', '”'); | |
update wp_comments set comment_content = replace(comment_content, '‹', '‹'); | |
update wp_comments set comment_content = replace(comment_content, '›', '›'); | |
update wp_comments set comment_content = replace(comment_content, '—', '—'); | |
update wp_comments set comment_content = replace(comment_content, '–', '—'); | |
update wp_comments set comment_content = replace(comment_content, 'â€?', '”'); | |
update wp_comments set comment_content = replace(comment_content, 'àƒ’', 'à'); | |
update wp_comments set comment_content = replace(comment_content, 'â’€’™', '’'); | |
update wp_comments set comment_content = replace(comment_content, 'â’€’œ', '“'); | |
update wp_comments set comment_content = replace(comment_content, 'â’€?', '”'); | |
update wp_comments set comment_content = replace(comment_content, 'àƒ’©', 'é'); | |
update wp_comments set comment_content = replace(comment_content, 'â’€’¦', ''); | |
update wp_comments set comment_content = replace(comment_content, '–', '\•'); | |
update wp_comments set comment_content = replace(comment_content, '€', '€'); | |
update wp_comments set comment_content = replace(comment_content, 'â€', '"'); | |
update wp_comments set comment_content = replace(comment_content, '–', '–'); | |
update wp_comments set comment_content = replace(comment_content, '•', '-'); | |
update wp_comments set comment_content = replace(comment_content, '“', '"'); | |
update wp_comments set comment_content = replace(comment_content, '¡', '¡'); | |
update wp_comments set comment_content = replace(comment_content, '¢', '¢'); | |
update wp_comments set comment_content = replace(comment_content, '£', '£'); | |
update wp_comments set comment_content = replace(comment_content, '¤', '¤'); | |
update wp_comments set comment_content = replace(comment_content, 'Â¥', '¥'); | |
update wp_comments set comment_content = replace(comment_content, '¦', '¦'); | |
update wp_comments set comment_content = replace(comment_content, '§', '§'); | |
update wp_comments set comment_content = replace(comment_content, '¨', '¨'); | |
update wp_comments set comment_content = replace(comment_content, '©', '©'); | |
update wp_comments set comment_content = replace(comment_content, 'ª', 'ª'); | |
update wp_comments set comment_content = replace(comment_content, '«', '«'); | |
update wp_comments set comment_content = replace(comment_content, '¬', '¬'); | |
update wp_comments set comment_content = replace(comment_content, 'Â', ''); | |
update wp_comments set comment_content = replace(comment_content, '®', '®'); | |
update wp_comments set comment_content = replace(comment_content, '¯', '¯'); | |
update wp_comments set comment_content = replace(comment_content, '°', '°'); | |
update wp_comments set comment_content = replace(comment_content, '±', '±'); | |
update wp_comments set comment_content = replace(comment_content, '²', '²'); | |
update wp_comments set comment_content = replace(comment_content, '³', '³'); | |
update wp_comments set comment_content = replace(comment_content, '´', '´'); | |
update wp_comments set comment_content = replace(comment_content, 'µ', 'µ'); | |
update wp_comments set comment_content = replace(comment_content, '¶', '¶'); | |
update wp_comments set comment_content = replace(comment_content, '·', '·'); | |
update wp_comments set comment_content = replace(comment_content, '¸', '¸'); | |
update wp_comments set comment_content = replace(comment_content, '¹', '¹'); | |
update wp_comments set comment_content = replace(comment_content, 'º', 'º'); | |
update wp_comments set comment_content = replace(comment_content, '»', '»'); | |
update wp_comments set comment_content = replace(comment_content, '¼', '¼'); | |
update wp_comments set comment_content = replace(comment_content, '½', '½'); | |
update wp_comments set comment_content = replace(comment_content, '¾', '¾'); | |
update wp_comments set comment_content = replace(comment_content, '¿', '¿'); | |
update wp_comments set comment_content = replace(comment_content, 'À', 'À'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Á'); | |
update wp_comments set comment_content = replace(comment_content, 'Â', 'Â'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Ã'); | |
update wp_comments set comment_content = replace(comment_content, 'Ä', 'Ä'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã…', 'Å'); | |
update wp_comments set comment_content = replace(comment_content, 'Æ', 'Æ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ç', 'Ç'); | |
update wp_comments set comment_content = replace(comment_content, 'È', 'È'); | |
update wp_comments set comment_content = replace(comment_content, 'É', 'É'); | |
update wp_comments set comment_content = replace(comment_content, 'Ê', 'Ê'); | |
update wp_comments set comment_content = replace(comment_content, 'Ë', 'Ë'); | |
update wp_comments set comment_content = replace(comment_content, 'ÃŒ', 'Ì'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Í'); | |
update wp_comments set comment_content = replace(comment_content, 'ÃŽ', 'Î'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Ï'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Ð'); | |
update wp_comments set comment_content = replace(comment_content, 'Ñ', 'Ñ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã’', 'Ò'); | |
update wp_comments set comment_content = replace(comment_content, 'Ó', 'Ó'); | |
update wp_comments set comment_content = replace(comment_content, 'Ô', 'Ô'); | |
update wp_comments set comment_content = replace(comment_content, 'Õ', 'Õ'); | |
update wp_comments set comment_content = replace(comment_content, 'Ö', 'Ö'); | |
update wp_comments set comment_content = replace(comment_content, '×', '×'); | |
update wp_comments set comment_content = replace(comment_content, 'Ø', 'Ø'); | |
update wp_comments set comment_content = replace(comment_content, 'Ù', 'Ù'); | |
update wp_comments set comment_content = replace(comment_content, 'Ú', 'Ú'); | |
update wp_comments set comment_content = replace(comment_content, 'Û', 'Û'); | |
update wp_comments set comment_content = replace(comment_content, 'Ãœ', 'Ü'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã', 'Ý'); | |
update wp_comments set comment_content = replace(comment_content, 'Þ', 'Þ'); | |
update wp_comments set comment_content = replace(comment_content, 'ß', 'ß'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã ', 'à'); | |
update wp_comments set comment_content = replace(comment_content, 'á', 'á'); | |
update wp_comments set comment_content = replace(comment_content, 'â', 'â'); | |
update wp_comments set comment_content = replace(comment_content, 'ã', 'ã'); | |
update wp_comments set comment_content = replace(comment_content, 'ä', 'ä'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã¥', 'å'); | |
update wp_comments set comment_content = replace(comment_content, 'æ', 'æ'); | |
update wp_comments set comment_content = replace(comment_content, 'ç', 'ç'); | |
update wp_comments set comment_content = replace(comment_content, 'è', 'è'); | |
update wp_comments set comment_content = replace(comment_content, 'é', 'é'); | |
update wp_comments set comment_content = replace(comment_content, 'ê', 'ê'); | |
update wp_comments set comment_content = replace(comment_content, 'ë', 'ë'); | |
update wp_comments set comment_content = replace(comment_content, 'ì', 'ì'); | |
update wp_comments set comment_content = replace(comment_content, 'Ã', 'í'); | |
update wp_comments set comment_content = replace(comment_content, 'î', 'î'); | |
update wp_comments set comment_content = replace(comment_content, 'ï', 'ï'); | |
update wp_comments set comment_content = replace(comment_content, 'ð', 'ð'); | |
update wp_comments set comment_content = replace(comment_content, 'ñ', 'ñ'); | |
update wp_comments set comment_content = replace(comment_content, 'ò', 'ò'); | |
update wp_comments set comment_content = replace(comment_content, 'ó', 'ó'); | |
update wp_comments set comment_content = replace(comment_content, 'ô', 'ô'); | |
update wp_comments set comment_content = replace(comment_content, 'õ', 'õ'); | |
update wp_comments set comment_content = replace(comment_content, 'ö', 'ö'); | |
update wp_comments set comment_content = replace(comment_content, '÷', '÷'); | |
update wp_comments set comment_content = replace(comment_content, 'ø', 'ø'); | |
update wp_comments set comment_content = replace(comment_content, 'ù', 'ù'); | |
update wp_comments set comment_content = replace(comment_content, 'ú', 'ú'); | |
update wp_comments set comment_content = replace(comment_content, 'û', 'û'); | |
update wp_comments set comment_content = replace(comment_content, 'ü', 'ü'); | |
update wp_comments set comment_content = replace(comment_content, 'ý', 'ý'); | |
update wp_comments set comment_content = replace(comment_content, 'þ', 'þ'); | |
update wp_comments set comment_content = replace(comment_content, 'ÿ', 'ÿ'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
update wp_postmeta set meta_value = replace(meta_value, 'α', 'α'); | |
update wp_postmeta set meta_value = replace(meta_value, 'β', 'β'); | |
update wp_postmeta set meta_value = replace(meta_value, 'γ', 'γ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'δ', 'δ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ε', 'ε'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ζ', 'ζ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'η', 'η'); | |
update wp_postmeta set meta_value = replace(meta_value, 'θ', 'θ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ι', 'ι'); | |
update wp_postmeta set meta_value = replace(meta_value, 'κ', 'κ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'λ', 'λ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'μ', 'μ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ν', 'ν'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ξ', 'ξ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ο', 'ο'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ï€', 'π'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ï', 'ρ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'σ', 'σ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ï„', 'τ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ï…', 'υ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'φ', 'φ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'χ', 'χ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ψ', 'ψ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ω', 'ω'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Α', 'Α'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Î’', 'Β'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Γ', 'Γ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Δ', 'Δ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ε', 'Ε'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ζ', 'Ζ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Η', 'Η'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Θ', 'Θ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ι', 'Ι'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Κ', 'Κ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Λ', 'Λ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Îœ', 'Μ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Î', 'Ν'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ξ', 'Ξ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ο', 'Ο'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Î ', 'Π'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ρ', 'Ρ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Σ', 'Σ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Τ', 'Τ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Î¥', 'Υ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Φ', 'Φ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Χ', 'Χ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ψ', 'Ψ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ω', 'Ω'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ά', 'ά'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Î', 'έ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ή', 'ή'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ί', 'ί'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ÏŒ', 'ό'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ï', 'ύ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ÏŽ', 'ώ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ά', 'Ά'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Έ', 'Έ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ή', 'Ή'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ί', 'Ί'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ÎŒ', 'Ό'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ÎŽ', 'Ύ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Î', 'Ώ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ï‹', 'ϋ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ΰ', 'υ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ÏŠ', 'ϊ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Î', 'ι'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ï‚', 'ς'); | |
update wp_postmeta set meta_value = replace(meta_value, '…', '…'); | |
update wp_postmeta set meta_value = replace(meta_value, '’', '’'); | |
update wp_postmeta set meta_value = replace(meta_value, 'àƒâ‚¬', 'ä'); | |
update wp_postmeta set meta_value = replace(meta_value, '‘', ''); | |
update wp_postmeta set meta_value = replace(meta_value, '“', '“'); | |
update wp_postmeta set meta_value = replace(meta_value, 'â€�', '”'); | |
update wp_postmeta set meta_value = replace(meta_value, '‹', '‹'); | |
update wp_postmeta set meta_value = replace(meta_value, '›', '›'); | |
update wp_postmeta set meta_value = replace(meta_value, '—', '—'); | |
update wp_postmeta set meta_value = replace(meta_value, '–', '—'); | |
update wp_postmeta set meta_value = replace(meta_value, 'â€?', '”'); | |
update wp_postmeta set meta_value = replace(meta_value, 'àƒ’', 'à'); | |
update wp_postmeta set meta_value = replace(meta_value, 'â’€’™', '’'); | |
update wp_postmeta set meta_value = replace(meta_value, 'â’€’œ', '“'); | |
update wp_postmeta set meta_value = replace(meta_value, 'â’€?', '”'); | |
update wp_postmeta set meta_value = replace(meta_value, 'àƒ’©', 'é'); | |
update wp_postmeta set meta_value = replace(meta_value, 'â’€’¦', ''); | |
update wp_postmeta set meta_value = replace(meta_value, '–', '\•'); | |
update wp_postmeta set meta_value = replace(meta_value, '€', '€'); | |
update wp_postmeta set meta_value = replace(meta_value, 'â€', '"'); | |
update wp_postmeta set meta_value = replace(meta_value, '–', '–'); | |
update wp_postmeta set meta_value = replace(meta_value, '•', '-'); | |
update wp_postmeta set meta_value = replace(meta_value, '“', '"'); | |
update wp_postmeta set meta_value = replace(meta_value, '¡', '¡'); | |
update wp_postmeta set meta_value = replace(meta_value, '¢', '¢'); | |
update wp_postmeta set meta_value = replace(meta_value, '£', '£'); | |
update wp_postmeta set meta_value = replace(meta_value, '¤', '¤'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Â¥', '¥'); | |
update wp_postmeta set meta_value = replace(meta_value, '¦', '¦'); | |
update wp_postmeta set meta_value = replace(meta_value, '§', '§'); | |
update wp_postmeta set meta_value = replace(meta_value, '¨', '¨'); | |
update wp_postmeta set meta_value = replace(meta_value, '©', '©'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ª', 'ª'); | |
update wp_postmeta set meta_value = replace(meta_value, '«', '«'); | |
update wp_postmeta set meta_value = replace(meta_value, '¬', '¬'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Â', ''); | |
update wp_postmeta set meta_value = replace(meta_value, '®', '®'); | |
update wp_postmeta set meta_value = replace(meta_value, '¯', '¯'); | |
update wp_postmeta set meta_value = replace(meta_value, '°', '°'); | |
update wp_postmeta set meta_value = replace(meta_value, '±', '±'); | |
update wp_postmeta set meta_value = replace(meta_value, '²', '²'); | |
update wp_postmeta set meta_value = replace(meta_value, '³', '³'); | |
update wp_postmeta set meta_value = replace(meta_value, '´', '´'); | |
update wp_postmeta set meta_value = replace(meta_value, 'µ', 'µ'); | |
update wp_postmeta set meta_value = replace(meta_value, '¶', '¶'); | |
update wp_postmeta set meta_value = replace(meta_value, '·', '·'); | |
update wp_postmeta set meta_value = replace(meta_value, '¸', '¸'); | |
update wp_postmeta set meta_value = replace(meta_value, '¹', '¹'); | |
update wp_postmeta set meta_value = replace(meta_value, 'º', 'º'); | |
update wp_postmeta set meta_value = replace(meta_value, '»', '»'); | |
update wp_postmeta set meta_value = replace(meta_value, '¼', '¼'); | |
update wp_postmeta set meta_value = replace(meta_value, '½', '½'); | |
update wp_postmeta set meta_value = replace(meta_value, '¾', '¾'); | |
update wp_postmeta set meta_value = replace(meta_value, '¿', '¿'); | |
update wp_postmeta set meta_value = replace(meta_value, 'À', 'À'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Á'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Â', 'Â'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Ã'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ä', 'Ä'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã…', 'Å'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Æ', 'Æ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ç', 'Ç'); | |
update wp_postmeta set meta_value = replace(meta_value, 'È', 'È'); | |
update wp_postmeta set meta_value = replace(meta_value, 'É', 'É'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ê', 'Ê'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ë', 'Ë'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ÃŒ', 'Ì'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Í'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ÃŽ', 'Î'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Ï'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Ð'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ñ', 'Ñ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã’', 'Ò'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ó', 'Ó'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ô', 'Ô'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Õ', 'Õ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ö', 'Ö'); | |
update wp_postmeta set meta_value = replace(meta_value, '×', '×'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ø', 'Ø'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ù', 'Ù'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ú', 'Ú'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Û', 'Û'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ãœ', 'Ü'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'Ý'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Þ', 'Þ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ß', 'ß'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã ', 'à'); | |
update wp_postmeta set meta_value = replace(meta_value, 'á', 'á'); | |
update wp_postmeta set meta_value = replace(meta_value, 'â', 'â'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ã', 'ã'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ä', 'ä'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã¥', 'å'); | |
update wp_postmeta set meta_value = replace(meta_value, 'æ', 'æ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ç', 'ç'); | |
update wp_postmeta set meta_value = replace(meta_value, 'è', 'è'); | |
update wp_postmeta set meta_value = replace(meta_value, 'é', 'é'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ê', 'ê'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ë', 'ë'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ì', 'ì'); | |
update wp_postmeta set meta_value = replace(meta_value, 'Ã', 'í'); | |
update wp_postmeta set meta_value = replace(meta_value, 'î', 'î'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ï', 'ï'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ð', 'ð'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ñ', 'ñ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ò', 'ò'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ó', 'ó'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ô', 'ô'); | |
update wp_postmeta set meta_value = replace(meta_value, 'õ', 'õ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ö', 'ö'); | |
update wp_postmeta set meta_value = replace(meta_value, '÷', '÷'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ø', 'ø'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ù', 'ù'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ú', 'ú'); | |
update wp_postmeta set meta_value = replace(meta_value, 'û', 'û'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ü', 'ü'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ý', 'ý'); | |
update wp_postmeta set meta_value = replace(meta_value, 'þ', 'þ'); | |
update wp_postmeta set meta_value = replace(meta_value, 'ÿ', 'ÿ'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
update wp_posts set post_content = replace(post_content, 'α', 'α'); | |
update wp_posts set post_content = replace(post_content, 'β', 'β'); | |
update wp_posts set post_content = replace(post_content, 'γ', 'γ'); | |
update wp_posts set post_content = replace(post_content, 'δ', 'δ'); | |
update wp_posts set post_content = replace(post_content, 'ε', 'ε'); | |
update wp_posts set post_content = replace(post_content, 'ζ', 'ζ'); | |
update wp_posts set post_content = replace(post_content, 'η', 'η'); | |
update wp_posts set post_content = replace(post_content, 'θ', 'θ'); | |
update wp_posts set post_content = replace(post_content, 'ι', 'ι'); | |
update wp_posts set post_content = replace(post_content, 'κ', 'κ'); | |
update wp_posts set post_content = replace(post_content, 'λ', 'λ'); | |
update wp_posts set post_content = replace(post_content, 'μ', 'μ'); | |
update wp_posts set post_content = replace(post_content, 'ν', 'ν'); | |
update wp_posts set post_content = replace(post_content, 'ξ', 'ξ'); | |
update wp_posts set post_content = replace(post_content, 'ο', 'ο'); | |
update wp_posts set post_content = replace(post_content, 'Ï€', 'π'); | |
update wp_posts set post_content = replace(post_content, 'Ï', 'ρ'); | |
update wp_posts set post_content = replace(post_content, 'σ', 'σ'); | |
update wp_posts set post_content = replace(post_content, 'Ï„', 'τ'); | |
update wp_posts set post_content = replace(post_content, 'Ï…', 'υ'); | |
update wp_posts set post_content = replace(post_content, 'φ', 'φ'); | |
update wp_posts set post_content = replace(post_content, 'χ', 'χ'); | |
update wp_posts set post_content = replace(post_content, 'ψ', 'ψ'); | |
update wp_posts set post_content = replace(post_content, 'ω', 'ω'); | |
update wp_posts set post_content = replace(post_content, 'Α', 'Α'); | |
update wp_posts set post_content = replace(post_content, 'Î’', 'Β'); | |
update wp_posts set post_content = replace(post_content, 'Γ', 'Γ'); | |
update wp_posts set post_content = replace(post_content, 'Δ', 'Δ'); | |
update wp_posts set post_content = replace(post_content, 'Ε', 'Ε'); | |
update wp_posts set post_content = replace(post_content, 'Ζ', 'Ζ'); | |
update wp_posts set post_content = replace(post_content, 'Η', 'Η'); | |
update wp_posts set post_content = replace(post_content, 'Θ', 'Θ'); | |
update wp_posts set post_content = replace(post_content, 'Ι', 'Ι'); | |
update wp_posts set post_content = replace(post_content, 'Κ', 'Κ'); | |
update wp_posts set post_content = replace(post_content, 'Λ', 'Λ'); | |
update wp_posts set post_content = replace(post_content, 'Îœ', 'Μ'); | |
update wp_posts set post_content = replace(post_content, 'Î', 'Ν'); | |
update wp_posts set post_content = replace(post_content, 'Ξ', 'Ξ'); | |
update wp_posts set post_content = replace(post_content, 'Ο', 'Ο'); | |
update wp_posts set post_content = replace(post_content, 'Î ', 'Π'); | |
update wp_posts set post_content = replace(post_content, 'Ρ', 'Ρ'); | |
update wp_posts set post_content = replace(post_content, 'Σ', 'Σ'); | |
update wp_posts set post_content = replace(post_content, 'Τ', 'Τ'); | |
update wp_posts set post_content = replace(post_content, 'Î¥', 'Υ'); | |
update wp_posts set post_content = replace(post_content, 'Φ', 'Φ'); | |
update wp_posts set post_content = replace(post_content, 'Χ', 'Χ'); | |
update wp_posts set post_content = replace(post_content, 'Ψ', 'Ψ'); | |
update wp_posts set post_content = replace(post_content, 'Ω', 'Ω'); | |
update wp_posts set post_content = replace(post_content, 'ά', 'ά'); | |
update wp_posts set post_content = replace(post_content, 'Î', 'έ'); | |
update wp_posts set post_content = replace(post_content, 'ή', 'ή'); | |
update wp_posts set post_content = replace(post_content, 'ί', 'ί'); | |
update wp_posts set post_content = replace(post_content, 'ÏŒ', 'ό'); | |
update wp_posts set post_content = replace(post_content, 'Ï', 'ύ'); | |
update wp_posts set post_content = replace(post_content, 'ÏŽ', 'ώ'); | |
update wp_posts set post_content = replace(post_content, 'Ά', 'Ά'); | |
update wp_posts set post_content = replace(post_content, 'Έ', 'Έ'); | |
update wp_posts set post_content = replace(post_content, 'Ή', 'Ή'); | |
update wp_posts set post_content = replace(post_content, 'Ί', 'Ί'); | |
update wp_posts set post_content = replace(post_content, 'ÎŒ', 'Ό'); | |
update wp_posts set post_content = replace(post_content, 'ÎŽ', 'Ύ'); | |
update wp_posts set post_content = replace(post_content, 'Î', 'Ώ'); | |
update wp_posts set post_content = replace(post_content, 'Ï‹', 'ϋ'); | |
update wp_posts set post_content = replace(post_content, 'ΰ', 'υ'); | |
update wp_posts set post_content = replace(post_content, 'ÏŠ', 'ϊ'); | |
update wp_posts set post_content = replace(post_content, 'Î', 'ι'); | |
update wp_posts set post_content = replace(post_content, 'Ï‚', 'ς'); | |
update wp_posts set post_content = replace(post_content, '…', '…'); | |
update wp_posts set post_content = replace(post_content, '’', '’'); | |
update wp_posts set post_content = replace(post_content, 'àƒâ‚¬', 'ä'); | |
update wp_posts set post_content = replace(post_content, '‘', ''); | |
update wp_posts set post_content = replace(post_content, '“', '“'); | |
update wp_posts set post_content = replace(post_content, 'â€�', '”'); | |
update wp_posts set post_content = replace(post_content, '‹', '‹'); | |
update wp_posts set post_content = replace(post_content, '›', '›'); | |
update wp_posts set post_content = replace(post_content, '—', '—'); | |
update wp_posts set post_content = replace(post_content, '–', '—'); | |
update wp_posts set post_content = replace(post_content, 'â€?', '”'); | |
update wp_posts set post_content = replace(post_content, 'àƒ’', 'à'); | |
update wp_posts set post_content = replace(post_content, 'â’€’™', '’'); | |
update wp_posts set post_content = replace(post_content, 'â’€’œ', '“'); | |
update wp_posts set post_content = replace(post_content, 'â’€?', '”'); | |
update wp_posts set post_content = replace(post_content, 'àƒ’©', 'é'); | |
update wp_posts set post_content = replace(post_content, 'â’€’¦', ''); | |
update wp_posts set post_content = replace(post_content, '–', '\•'); | |
update wp_posts set post_content = replace(post_content, '€', '€'); | |
update wp_posts set post_content = replace(post_content, 'â€', '"'); | |
update wp_posts set post_content = replace(post_content, '–', '–'); | |
update wp_posts set post_content = replace(post_content, '•', '-'); | |
update wp_posts set post_content = replace(post_content, '“', '"'); | |
update wp_posts set post_content = replace(post_content, '¡', '¡'); | |
update wp_posts set post_content = replace(post_content, '¢', '¢'); | |
update wp_posts set post_content = replace(post_content, '£', '£'); | |
update wp_posts set post_content = replace(post_content, '¤', '¤'); | |
update wp_posts set post_content = replace(post_content, 'Â¥', '¥'); | |
update wp_posts set post_content = replace(post_content, '¦', '¦'); | |
update wp_posts set post_content = replace(post_content, '§', '§'); | |
update wp_posts set post_content = replace(post_content, '¨', '¨'); | |
update wp_posts set post_content = replace(post_content, '©', '©'); | |
update wp_posts set post_content = replace(post_content, 'ª', 'ª'); | |
update wp_posts set post_content = replace(post_content, '«', '«'); | |
update wp_posts set post_content = replace(post_content, '¬', '¬'); | |
update wp_posts set post_content = replace(post_content, 'Â', ''); | |
update wp_posts set post_content = replace(post_content, '®', '®'); | |
update wp_posts set post_content = replace(post_content, '¯', '¯'); | |
update wp_posts set post_content = replace(post_content, '°', '°'); | |
update wp_posts set post_content = replace(post_content, '±', '±'); | |
update wp_posts set post_content = replace(post_content, '²', '²'); | |
update wp_posts set post_content = replace(post_content, '³', '³'); | |
update wp_posts set post_content = replace(post_content, '´', '´'); | |
update wp_posts set post_content = replace(post_content, 'µ', 'µ'); | |
update wp_posts set post_content = replace(post_content, '¶', '¶'); | |
update wp_posts set post_content = replace(post_content, '·', '·'); | |
update wp_posts set post_content = replace(post_content, '¸', '¸'); | |
update wp_posts set post_content = replace(post_content, '¹', '¹'); | |
update wp_posts set post_content = replace(post_content, 'º', 'º'); | |
update wp_posts set post_content = replace(post_content, '»', '»'); | |
update wp_posts set post_content = replace(post_content, '¼', '¼'); | |
update wp_posts set post_content = replace(post_content, '½', '½'); | |
update wp_posts set post_content = replace(post_content, '¾', '¾'); | |
update wp_posts set post_content = replace(post_content, '¿', '¿'); | |
update wp_posts set post_content = replace(post_content, 'À', 'À'); | |
update wp_posts set post_content = replace(post_content, 'Ã', 'Á'); | |
update wp_posts set post_content = replace(post_content, 'Â', 'Â'); | |
update wp_posts set post_content = replace(post_content, 'Ã', 'Ã'); | |
update wp_posts set post_content = replace(post_content, 'Ä', 'Ä'); | |
update wp_posts set post_content = replace(post_content, 'Ã…', 'Å'); | |
update wp_posts set post_content = replace(post_content, 'Æ', 'Æ'); | |
update wp_posts set post_content = replace(post_content, 'Ç', 'Ç'); | |
update wp_posts set post_content = replace(post_content, 'È', 'È'); | |
update wp_posts set post_content = replace(post_content, 'É', 'É'); | |
update wp_posts set post_content = replace(post_content, 'Ê', 'Ê'); | |
update wp_posts set post_content = replace(post_content, 'Ë', 'Ë'); | |
update wp_posts set post_content = replace(post_content, 'ÃŒ', 'Ì'); | |
update wp_posts set post_content = replace(post_content, 'Ã', 'Í'); | |
update wp_posts set post_content = replace(post_content, 'ÃŽ', 'Î'); | |
update wp_posts set post_content = replace(post_content, 'Ã', 'Ï'); | |
update wp_posts set post_content = replace(post_content, 'Ã', 'Ð'); | |
update wp_posts set post_content = replace(post_content, 'Ñ', 'Ñ'); | |
update wp_posts set post_content = replace(post_content, 'Ã’', 'Ò'); | |
update wp_posts set post_content = replace(post_content, 'Ó', 'Ó'); | |
update wp_posts set post_content = replace(post_content, 'Ô', 'Ô'); | |
update wp_posts set post_content = replace(post_content, 'Õ', 'Õ'); | |
update wp_posts set post_content = replace(post_content, 'Ö', 'Ö'); | |
update wp_posts set post_content = replace(post_content, '×', '×'); | |
update wp_posts set post_content = replace(post_content, 'Ø', 'Ø'); | |
update wp_posts set post_content = replace(post_content, 'Ù', 'Ù'); | |
update wp_posts set post_content = replace(post_content, 'Ú', 'Ú'); | |
update wp_posts set post_content = replace(post_content, 'Û', 'Û'); | |
update wp_posts set post_content = replace(post_content, 'Ãœ', 'Ü'); | |
update wp_posts set post_content = replace(post_content, 'Ã', 'Ý'); | |
update wp_posts set post_content = replace(post_content, 'Þ', 'Þ'); | |
update wp_posts set post_content = replace(post_content, 'ß', 'ß'); | |
update wp_posts set post_content = replace(post_content, 'Ã ', 'à'); | |
update wp_posts set post_content = replace(post_content, 'á', 'á'); | |
update wp_posts set post_content = replace(post_content, 'â', 'â'); | |
update wp_posts set post_content = replace(post_content, 'ã', 'ã'); | |
update wp_posts set post_content = replace(post_content, 'ä', 'ä'); | |
update wp_posts set post_content = replace(post_content, 'Ã¥', 'å'); | |
update wp_posts set post_content = replace(post_content, 'æ', 'æ'); | |
update wp_posts set post_content = replace(post_content, 'ç', 'ç'); | |
update wp_posts set post_content = replace(post_content, 'è', 'è'); | |
update wp_posts set post_content = replace(post_content, 'é', 'é'); | |
update wp_posts set post_content = replace(post_content, 'ê', 'ê'); | |
update wp_posts set post_content = replace(post_content, 'ë', 'ë'); | |
update wp_posts set post_content = replace(post_content, 'ì', 'ì'); | |
update wp_posts set post_content = replace(post_content, 'Ã', 'í'); | |
update wp_posts set post_content = replace(post_content, 'î', 'î'); | |
update wp_posts set post_content = replace(post_content, 'ï', 'ï'); | |
update wp_posts set post_content = replace(post_content, 'ð', 'ð'); | |
update wp_posts set post_content = replace(post_content, 'ñ', 'ñ'); | |
update wp_posts set post_content = replace(post_content, 'ò', 'ò'); | |
update wp_posts set post_content = replace(post_content, 'ó', 'ó'); | |
update wp_posts set post_content = replace(post_content, 'ô', 'ô'); | |
update wp_posts set post_content = replace(post_content, 'õ', 'õ'); | |
update wp_posts set post_content = replace(post_content, 'ö', 'ö'); | |
update wp_posts set post_content = replace(post_content, '÷', '÷'); | |
update wp_posts set post_content = replace(post_content, 'ø', 'ø'); | |
update wp_posts set post_content = replace(post_content, 'ù', 'ù'); | |
update wp_posts set post_content = replace(post_content, 'ú', 'ú'); | |
update wp_posts set post_content = replace(post_content, 'û', 'û'); | |
update wp_posts set post_content = replace(post_content, 'ü', 'ü'); | |
update wp_posts set post_content = replace(post_content, 'ý', 'ý'); | |
update wp_posts set post_content = replace(post_content, 'þ', 'þ'); | |
update wp_posts set post_content = replace(post_content, 'ÿ', 'ÿ'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
update wp_posts set post_excerpt = replace(post_excerpt, 'α', 'α'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'β', 'β'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'γ', 'γ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'δ', 'δ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ε', 'ε'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ζ', 'ζ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'η', 'η'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'θ', 'θ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ι', 'ι'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'κ', 'κ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'λ', 'λ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'μ', 'μ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ν', 'ν'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ξ', 'ξ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ο', 'ο'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï€', 'π'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï', 'ρ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'σ', 'σ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï„', 'τ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï…', 'υ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'φ', 'φ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'χ', 'χ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ψ', 'ψ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ω', 'ω'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Α', 'Α'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Î’', 'Β'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Γ', 'Γ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Δ', 'Δ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ε', 'Ε'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ζ', 'Ζ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Η', 'Η'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Θ', 'Θ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ι', 'Ι'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Κ', 'Κ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Λ', 'Λ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Îœ', 'Μ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Î', 'Ν'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ξ', 'Ξ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ο', 'Ο'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Î ', 'Π'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ρ', 'Ρ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Σ', 'Σ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Τ', 'Τ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Î¥', 'Υ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Φ', 'Φ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Χ', 'Χ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ψ', 'Ψ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ω', 'Ω'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ά', 'ά'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Î', 'έ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ή', 'ή'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ί', 'ί'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ÏŒ', 'ό'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï', 'ύ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ÏŽ', 'ώ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ά', 'Ά'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Έ', 'Έ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ή', 'Ή'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ί', 'Ί'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ÎŒ', 'Ό'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ÎŽ', 'Ύ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Î', 'Ώ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï‹', 'ϋ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ΰ', 'υ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ÏŠ', 'ϊ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Î', 'ι'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ï‚', 'ς'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '…', '…'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '’', '’'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'àƒâ‚¬', 'ä'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '‘', ''); | |
update wp_posts set post_excerpt = replace(post_excerpt, '“', '“'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'â€�', '”'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '‹', '‹'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '›', '›'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '—', '—'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '–', '—'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'â€?', '”'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'àƒ’', 'à'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'â’€’™', '’'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'â’€’œ', '“'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'â’€?', '”'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'àƒ’©', 'é'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'â’€’¦', ''); | |
update wp_posts set post_excerpt = replace(post_excerpt, '–', '\•'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '€', '€'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'â€', '"'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '–', '–'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '•', '-'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '“', '"'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¡', '¡'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¢', '¢'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '£', '£'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¤', '¤'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Â¥', '¥'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¦', '¦'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '§', '§'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¨', '¨'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '©', '©'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ª', 'ª'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '«', '«'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¬', '¬'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Â', ''); | |
update wp_posts set post_excerpt = replace(post_excerpt, '®', '®'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¯', '¯'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '°', '°'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '±', '±'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '²', '²'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '³', '³'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '´', '´'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'µ', 'µ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¶', '¶'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '·', '·'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¸', '¸'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¹', '¹'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'º', 'º'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '»', '»'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¼', '¼'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '½', '½'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¾', '¾'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '¿', '¿'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'À', 'À'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Á'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Â', 'Â'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Ã'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ä', 'Ä'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã…', 'Å'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Æ', 'Æ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ç', 'Ç'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'È', 'È'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'É', 'É'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ê', 'Ê'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ë', 'Ë'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ÃŒ', 'Ì'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Í'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ÃŽ', 'Î'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Ï'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Ð'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ñ', 'Ñ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã’', 'Ò'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ó', 'Ó'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ô', 'Ô'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Õ', 'Õ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ö', 'Ö'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '×', '×'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ø', 'Ø'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ù', 'Ù'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ú', 'Ú'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Û', 'Û'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ãœ', 'Ü'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'Ý'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Þ', 'Þ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ß', 'ß'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã ', 'à'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'á', 'á'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'â', 'â'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ã', 'ã'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ä', 'ä'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã¥', 'å'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'æ', 'æ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ç', 'ç'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'è', 'è'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'é', 'é'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ê', 'ê'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ë', 'ë'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ì', 'ì'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'Ã', 'í'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'î', 'î'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ï', 'ï'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ð', 'ð'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ñ', 'ñ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ò', 'ò'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ó', 'ó'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ô', 'ô'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'õ', 'õ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ö', 'ö'); | |
update wp_posts set post_excerpt = replace(post_excerpt, '÷', '÷'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ø', 'ø'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ù', 'ù'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ú', 'ú'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'û', 'û'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ü', 'ü'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ý', 'ý'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'þ', 'þ'); | |
update wp_posts set post_excerpt = replace(post_excerpt, 'ÿ', 'ÿ'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
update wp_posts set post_title = replace(post_title, 'α', 'α'); | |
update wp_posts set post_title = replace(post_title, 'β', 'β'); | |
update wp_posts set post_title = replace(post_title, 'γ', 'γ'); | |
update wp_posts set post_title = replace(post_title, 'δ', 'δ'); | |
update wp_posts set post_title = replace(post_title, 'ε', 'ε'); | |
update wp_posts set post_title = replace(post_title, 'ζ', 'ζ'); | |
update wp_posts set post_title = replace(post_title, 'η', 'η'); | |
update wp_posts set post_title = replace(post_title, 'θ', 'θ'); | |
update wp_posts set post_title = replace(post_title, 'ι', 'ι'); | |
update wp_posts set post_title = replace(post_title, 'κ', 'κ'); | |
update wp_posts set post_title = replace(post_title, 'λ', 'λ'); | |
update wp_posts set post_title = replace(post_title, 'μ', 'μ'); | |
update wp_posts set post_title = replace(post_title, 'ν', 'ν'); | |
update wp_posts set post_title = replace(post_title, 'ξ', 'ξ'); | |
update wp_posts set post_title = replace(post_title, 'ο', 'ο'); | |
update wp_posts set post_title = replace(post_title, 'Ï€', 'π'); | |
update wp_posts set post_title = replace(post_title, 'Ï', 'ρ'); | |
update wp_posts set post_title = replace(post_title, 'σ', 'σ'); | |
update wp_posts set post_title = replace(post_title, 'Ï„', 'τ'); | |
update wp_posts set post_title = replace(post_title, 'Ï…', 'υ'); | |
update wp_posts set post_title = replace(post_title, 'φ', 'φ'); | |
update wp_posts set post_title = replace(post_title, 'χ', 'χ'); | |
update wp_posts set post_title = replace(post_title, 'ψ', 'ψ'); | |
update wp_posts set post_title = replace(post_title, 'ω', 'ω'); | |
update wp_posts set post_title = replace(post_title, 'Α', 'Α'); | |
update wp_posts set post_title = replace(post_title, 'Î’', 'Β'); | |
update wp_posts set post_title = replace(post_title, 'Γ', 'Γ'); | |
update wp_posts set post_title = replace(post_title, 'Δ', 'Δ'); | |
update wp_posts set post_title = replace(post_title, 'Ε', 'Ε'); | |
update wp_posts set post_title = replace(post_title, 'Ζ', 'Ζ'); | |
update wp_posts set post_title = replace(post_title, 'Η', 'Η'); | |
update wp_posts set post_title = replace(post_title, 'Θ', 'Θ'); | |
update wp_posts set post_title = replace(post_title, 'Ι', 'Ι'); | |
update wp_posts set post_title = replace(post_title, 'Κ', 'Κ'); | |
update wp_posts set post_title = replace(post_title, 'Λ', 'Λ'); | |
update wp_posts set post_title = replace(post_title, 'Îœ', 'Μ'); | |
update wp_posts set post_title = replace(post_title, 'Î', 'Ν'); | |
update wp_posts set post_title = replace(post_title, 'Ξ', 'Ξ'); | |
update wp_posts set post_title = replace(post_title, 'Ο', 'Ο'); | |
update wp_posts set post_title = replace(post_title, 'Î ', 'Π'); | |
update wp_posts set post_title = replace(post_title, 'Ρ', 'Ρ'); | |
update wp_posts set post_title = replace(post_title, 'Σ', 'Σ'); | |
update wp_posts set post_title = replace(post_title, 'Τ', 'Τ'); | |
update wp_posts set post_title = replace(post_title, 'Î¥', 'Υ'); | |
update wp_posts set post_title = replace(post_title, 'Φ', 'Φ'); | |
update wp_posts set post_title = replace(post_title, 'Χ', 'Χ'); | |
update wp_posts set post_title = replace(post_title, 'Ψ', 'Ψ'); | |
update wp_posts set post_title = replace(post_title, 'Ω', 'Ω'); | |
update wp_posts set post_title = replace(post_title, 'ά', 'ά'); | |
update wp_posts set post_title = replace(post_title, 'Î', 'έ'); | |
update wp_posts set post_title = replace(post_title, 'ή', 'ή'); | |
update wp_posts set post_title = replace(post_title, 'ί', 'ί'); | |
update wp_posts set post_title = replace(post_title, 'ÏŒ', 'ό'); | |
update wp_posts set post_title = replace(post_title, 'Ï', 'ύ'); | |
update wp_posts set post_title = replace(post_title, 'ÏŽ', 'ώ'); | |
update wp_posts set post_title = replace(post_title, 'Ά', 'Ά'); | |
update wp_posts set post_title = replace(post_title, 'Έ', 'Έ'); | |
update wp_posts set post_title = replace(post_title, 'Ή', 'Ή'); | |
update wp_posts set post_title = replace(post_title, 'Ί', 'Ί'); | |
update wp_posts set post_title = replace(post_title, 'ÎŒ', 'Ό'); | |
update wp_posts set post_title = replace(post_title, 'ÎŽ', 'Ύ'); | |
update wp_posts set post_title = replace(post_title, 'Î', 'Ώ'); | |
update wp_posts set post_title = replace(post_title, 'Ï‹', 'ϋ'); | |
update wp_posts set post_title = replace(post_title, 'ΰ', 'υ'); | |
update wp_posts set post_title = replace(post_title, 'ÏŠ', 'ϊ'); | |
update wp_posts set post_title = replace(post_title, 'Î', 'ι'); | |
update wp_posts set post_title = replace(post_title, 'Ï‚', 'ς'); | |
update wp_posts set post_title = replace(post_title, '…', '…'); | |
update wp_posts set post_title = replace(post_title, '’', '’'); | |
update wp_posts set post_title = replace(post_title, 'àƒâ‚¬', 'ä'); | |
update wp_posts set post_title = replace(post_title, '‘', ''); | |
update wp_posts set post_title = replace(post_title, '“', '“'); | |
update wp_posts set post_title = replace(post_title, 'â€�', '”'); | |
update wp_posts set post_title = replace(post_title, '‹', '‹'); | |
update wp_posts set post_title = replace(post_title, '›', '›'); | |
update wp_posts set post_title = replace(post_title, '—', '—'); | |
update wp_posts set post_title = replace(post_title, '–', '—'); | |
update wp_posts set post_title = replace(post_title, 'â€?', '”'); | |
update wp_posts set post_title = replace(post_title, 'àƒ’', 'à'); | |
update wp_posts set post_title = replace(post_title, 'â’€’™', '’'); | |
update wp_posts set post_title = replace(post_title, 'â’€’œ', '“'); | |
update wp_posts set post_title = replace(post_title, 'â’€?', '”'); | |
update wp_posts set post_title = replace(post_title, 'àƒ’©', 'é'); | |
update wp_posts set post_title = replace(post_title, 'â’€’¦', ''); | |
update wp_posts set post_title = replace(post_title, '–', '\•'); | |
update wp_posts set post_title = replace(post_title, '€', '€'); | |
update wp_posts set post_title = replace(post_title, 'â€', '"'); | |
update wp_posts set post_title = replace(post_title, '–', '–'); | |
update wp_posts set post_title = replace(post_title, '•', '-'); | |
update wp_posts set post_title = replace(post_title, '“', '"'); | |
update wp_posts set post_title = replace(post_title, '¡', '¡'); | |
update wp_posts set post_title = replace(post_title, '¢', '¢'); | |
update wp_posts set post_title = replace(post_title, '£', '£'); | |
update wp_posts set post_title = replace(post_title, '¤', '¤'); | |
update wp_posts set post_title = replace(post_title, 'Â¥', '¥'); | |
update wp_posts set post_title = replace(post_title, '¦', '¦'); | |
update wp_posts set post_title = replace(post_title, '§', '§'); | |
update wp_posts set post_title = replace(post_title, '¨', '¨'); | |
update wp_posts set post_title = replace(post_title, '©', '©'); | |
update wp_posts set post_title = replace(post_title, 'ª', 'ª'); | |
update wp_posts set post_title = replace(post_title, '«', '«'); | |
update wp_posts set post_title = replace(post_title, '¬', '¬'); | |
update wp_posts set post_title = replace(post_title, 'Â', ''); | |
update wp_posts set post_title = replace(post_title, '®', '®'); | |
update wp_posts set post_title = replace(post_title, '¯', '¯'); | |
update wp_posts set post_title = replace(post_title, '°', '°'); | |
update wp_posts set post_title = replace(post_title, '±', '±'); | |
update wp_posts set post_title = replace(post_title, '²', '²'); | |
update wp_posts set post_title = replace(post_title, '³', '³'); | |
update wp_posts set post_title = replace(post_title, '´', '´'); | |
update wp_posts set post_title = replace(post_title, 'µ', 'µ'); | |
update wp_posts set post_title = replace(post_title, '¶', '¶'); | |
update wp_posts set post_title = replace(post_title, '·', '·'); | |
update wp_posts set post_title = replace(post_title, '¸', '¸'); | |
update wp_posts set post_title = replace(post_title, '¹', '¹'); | |
update wp_posts set post_title = replace(post_title, 'º', 'º'); | |
update wp_posts set post_title = replace(post_title, '»', '»'); | |
update wp_posts set post_title = replace(post_title, '¼', '¼'); | |
update wp_posts set post_title = replace(post_title, '½', '½'); | |
update wp_posts set post_title = replace(post_title, '¾', '¾'); | |
update wp_posts set post_title = replace(post_title, '¿', '¿'); | |
update wp_posts set post_title = replace(post_title, 'À', 'À'); | |
update wp_posts set post_title = replace(post_title, 'Ã', 'Á'); | |
update wp_posts set post_title = replace(post_title, 'Â', 'Â'); | |
update wp_posts set post_title = replace(post_title, 'Ã', 'Ã'); | |
update wp_posts set post_title = replace(post_title, 'Ä', 'Ä'); | |
update wp_posts set post_title = replace(post_title, 'Ã…', 'Å'); | |
update wp_posts set post_title = replace(post_title, 'Æ', 'Æ'); | |
update wp_posts set post_title = replace(post_title, 'Ç', 'Ç'); | |
update wp_posts set post_title = replace(post_title, 'È', 'È'); | |
update wp_posts set post_title = replace(post_title, 'É', 'É'); | |
update wp_posts set post_title = replace(post_title, 'Ê', 'Ê'); | |
update wp_posts set post_title = replace(post_title, 'Ë', 'Ë'); | |
update wp_posts set post_title = replace(post_title, 'ÃŒ', 'Ì'); | |
update wp_posts set post_title = replace(post_title, 'Ã', 'Í'); | |
update wp_posts set post_title = replace(post_title, 'ÃŽ', 'Î'); | |
update wp_posts set post_title = replace(post_title, 'Ã', 'Ï'); | |
update wp_posts set post_title = replace(post_title, 'Ã', 'Ð'); | |
update wp_posts set post_title = replace(post_title, 'Ñ', 'Ñ'); | |
update wp_posts set post_title = replace(post_title, 'Ã’', 'Ò'); | |
update wp_posts set post_title = replace(post_title, 'Ó', 'Ó'); | |
update wp_posts set post_title = replace(post_title, 'Ô', 'Ô'); | |
update wp_posts set post_title = replace(post_title, 'Õ', 'Õ'); | |
update wp_posts set post_title = replace(post_title, 'Ö', 'Ö'); | |
update wp_posts set post_title = replace(post_title, '×', '×'); | |
update wp_posts set post_title = replace(post_title, 'Ø', 'Ø'); | |
update wp_posts set post_title = replace(post_title, 'Ù', 'Ù'); | |
update wp_posts set post_title = replace(post_title, 'Ú', 'Ú'); | |
update wp_posts set post_title = replace(post_title, 'Û', 'Û'); | |
update wp_posts set post_title = replace(post_title, 'Ãœ', 'Ü'); | |
update wp_posts set post_title = replace(post_title, 'Ã', 'Ý'); | |
update wp_posts set post_title = replace(post_title, 'Þ', 'Þ'); | |
update wp_posts set post_title = replace(post_title, 'ß', 'ß'); | |
update wp_posts set post_title = replace(post_title, 'Ã ', 'à'); | |
update wp_posts set post_title = replace(post_title, 'á', 'á'); | |
update wp_posts set post_title = replace(post_title, 'â', 'â'); | |
update wp_posts set post_title = replace(post_title, 'ã', 'ã'); | |
update wp_posts set post_title = replace(post_title, 'ä', 'ä'); | |
update wp_posts set post_title = replace(post_title, 'Ã¥', 'å'); | |
update wp_posts set post_title = replace(post_title, 'æ', 'æ'); | |
update wp_posts set post_title = replace(post_title, 'ç', 'ç'); | |
update wp_posts set post_title = replace(post_title, 'è', 'è'); | |
update wp_posts set post_title = replace(post_title, 'é', 'é'); | |
update wp_posts set post_title = replace(post_title, 'ê', 'ê'); | |
update wp_posts set post_title = replace(post_title, 'ë', 'ë'); | |
update wp_posts set post_title = replace(post_title, 'ì', 'ì'); | |
update wp_posts set post_title = replace(post_title, 'Ã', 'í'); | |
update wp_posts set post_title = replace(post_title, 'î', 'î'); | |
update wp_posts set post_title = replace(post_title, 'ï', 'ï'); | |
update wp_posts set post_title = replace(post_title, 'ð', 'ð'); | |
update wp_posts set post_title = replace(post_title, 'ñ', 'ñ'); | |
update wp_posts set post_title = replace(post_title, 'ò', 'ò'); | |
update wp_posts set post_title = replace(post_title, 'ó', 'ó'); | |
update wp_posts set post_title = replace(post_title, 'ô', 'ô'); | |
update wp_posts set post_title = replace(post_title, 'õ', 'õ'); | |
update wp_posts set post_title = replace(post_title, 'ö', 'ö'); | |
update wp_posts set post_title = replace(post_title, '÷', '÷'); | |
update wp_posts set post_title = replace(post_title, 'ø', 'ø'); | |
update wp_posts set post_title = replace(post_title, 'ù', 'ù'); | |
update wp_posts set post_title = replace(post_title, 'ú', 'ú'); | |
update wp_posts set post_title = replace(post_title, 'û', 'û'); | |
update wp_posts set post_title = replace(post_title, 'ü', 'ü'); | |
update wp_posts set post_title = replace(post_title, 'ý', 'ý'); | |
update wp_posts set post_title = replace(post_title, 'þ', 'þ'); | |
update wp_posts set post_title = replace(post_title, 'ÿ', 'ÿ'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
update wp_terms set name = replace(name, 'α', 'α'); | |
update wp_terms set name = replace(name, 'β', 'β'); | |
update wp_terms set name = replace(name, 'γ', 'γ'); | |
update wp_terms set name = replace(name, 'δ', 'δ'); | |
update wp_terms set name = replace(name, 'ε', 'ε'); | |
update wp_terms set name = replace(name, 'ζ', 'ζ'); | |
update wp_terms set name = replace(name, 'η', 'η'); | |
update wp_terms set name = replace(name, 'θ', 'θ'); | |
update wp_terms set name = replace(name, 'ι', 'ι'); | |
update wp_terms set name = replace(name, 'κ', 'κ'); | |
update wp_terms set name = replace(name, 'λ', 'λ'); | |
update wp_terms set name = replace(name, 'μ', 'μ'); | |
update wp_terms set name = replace(name, 'ν', 'ν'); | |
update wp_terms set name = replace(name, 'ξ', 'ξ'); | |
update wp_terms set name = replace(name, 'ο', 'ο'); | |
update wp_terms set name = replace(name, 'Ï€', 'π'); | |
update wp_terms set name = replace(name, 'Ï', 'ρ'); | |
update wp_terms set name = replace(name, 'σ', 'σ'); | |
update wp_terms set name = replace(name, 'Ï„', 'τ'); | |
update wp_terms set name = replace(name, 'Ï…', 'υ'); | |
update wp_terms set name = replace(name, 'φ', 'φ'); | |
update wp_terms set name = replace(name, 'χ', 'χ'); | |
update wp_terms set name = replace(name, 'ψ', 'ψ'); | |
update wp_terms set name = replace(name, 'ω', 'ω'); | |
update wp_terms set name = replace(name, 'Α', 'Α'); | |
update wp_terms set name = replace(name, 'Î’', 'Β'); | |
update wp_terms set name = replace(name, 'Γ', 'Γ'); | |
update wp_terms set name = replace(name, 'Δ', 'Δ'); | |
update wp_terms set name = replace(name, 'Ε', 'Ε'); | |
update wp_terms set name = replace(name, 'Ζ', 'Ζ'); | |
update wp_terms set name = replace(name, 'Η', 'Η'); | |
update wp_terms set name = replace(name, 'Θ', 'Θ'); | |
update wp_terms set name = replace(name, 'Ι', 'Ι'); | |
update wp_terms set name = replace(name, 'Κ', 'Κ'); | |
update wp_terms set name = replace(name, 'Λ', 'Λ'); | |
update wp_terms set name = replace(name, 'Îœ', 'Μ'); | |
update wp_terms set name = replace(name, 'Î', 'Ν'); | |
update wp_terms set name = replace(name, 'Ξ', 'Ξ'); | |
update wp_terms set name = replace(name, 'Ο', 'Ο'); | |
update wp_terms set name = replace(name, 'Î ', 'Π'); | |
update wp_terms set name = replace(name, 'Ρ', 'Ρ'); | |
update wp_terms set name = replace(name, 'Σ', 'Σ'); | |
update wp_terms set name = replace(name, 'Τ', 'Τ'); | |
update wp_terms set name = replace(name, 'Î¥', 'Υ'); | |
update wp_terms set name = replace(name, 'Φ', 'Φ'); | |
update wp_terms set name = replace(name, 'Χ', 'Χ'); | |
update wp_terms set name = replace(name, 'Ψ', 'Ψ'); | |
update wp_terms set name = replace(name, 'Ω', 'Ω'); | |
update wp_terms set name = replace(name, 'ά', 'ά'); | |
update wp_terms set name = replace(name, 'Î', 'έ'); | |
update wp_terms set name = replace(name, 'ή', 'ή'); | |
update wp_terms set name = replace(name, 'ί', 'ί'); | |
update wp_terms set name = replace(name, 'ÏŒ', 'ό'); | |
update wp_terms set name = replace(name, 'Ï', 'ύ'); | |
update wp_terms set name = replace(name, 'ÏŽ', 'ώ'); | |
update wp_terms set name = replace(name, 'Ά', 'Ά'); | |
update wp_terms set name = replace(name, 'Έ', 'Έ'); | |
update wp_terms set name = replace(name, 'Ή', 'Ή'); | |
update wp_terms set name = replace(name, 'Ί', 'Ί'); | |
update wp_terms set name = replace(name, 'ÎŒ', 'Ό'); | |
update wp_terms set name = replace(name, 'ÎŽ', 'Ύ'); | |
update wp_terms set name = replace(name, 'Î', 'Ώ'); | |
update wp_terms set name = replace(name, 'Ï‹', 'ϋ'); | |
update wp_terms set name = replace(name, 'ΰ', 'υ'); | |
update wp_terms set name = replace(name, 'ÏŠ', 'ϊ'); | |
update wp_terms set name = replace(name, 'Î', 'ι'); | |
update wp_terms set name = replace(name, 'Ï‚', 'ς'); | |
update wp_terms set name = replace(name, '…', '…'); | |
update wp_terms set name = replace(name, '’', '’'); | |
update wp_terms set name = replace(name, 'àƒâ‚¬', 'ä'); | |
update wp_terms set name = replace(name, '‘', ''); | |
update wp_terms set name = replace(name, '“', '“'); | |
update wp_terms set name = replace(name, 'â€�', '”'); | |
update wp_terms set name = replace(name, '‹', '‹'); | |
update wp_terms set name = replace(name, '›', '›'); | |
update wp_terms set name = replace(name, '—', '—'); | |
update wp_terms set name = replace(name, '–', '—'); | |
update wp_terms set name = replace(name, 'â€?', '”'); | |
update wp_terms set name = replace(name, 'àƒ’', 'à'); | |
update wp_terms set name = replace(name, 'â’€’™', '’'); | |
update wp_terms set name = replace(name, 'â’€’œ', '“'); | |
update wp_terms set name = replace(name, 'â’€?', '”'); | |
update wp_terms set name = replace(name, 'àƒ’©', 'é'); | |
update wp_terms set name = replace(name, 'â’€’¦', ''); | |
update wp_terms set name = replace(name, '–', '\•'); | |
update wp_terms set name = replace(name, '€', '€'); | |
update wp_terms set name = replace(name, 'â€', '"'); | |
update wp_terms set name = replace(name, '–', '–'); | |
update wp_terms set name = replace(name, '•', '-'); | |
update wp_terms set name = replace(name, '“', '"'); | |
update wp_terms set name = replace(name, '¡', '¡'); | |
update wp_terms set name = replace(name, '¢', '¢'); | |
update wp_terms set name = replace(name, '£', '£'); | |
update wp_terms set name = replace(name, '¤', '¤'); | |
update wp_terms set name = replace(name, 'Â¥', '¥'); | |
update wp_terms set name = replace(name, '¦', '¦'); | |
update wp_terms set name = replace(name, '§', '§'); | |
update wp_terms set name = replace(name, '¨', '¨'); | |
update wp_terms set name = replace(name, '©', '©'); | |
update wp_terms set name = replace(name, 'ª', 'ª'); | |
update wp_terms set name = replace(name, '«', '«'); | |
update wp_terms set name = replace(name, '¬', '¬'); | |
update wp_terms set name = replace(name, 'Â', ''); | |
update wp_terms set name = replace(name, '®', '®'); | |
update wp_terms set name = replace(name, '¯', '¯'); | |
update wp_terms set name = replace(name, '°', '°'); | |
update wp_terms set name = replace(name, '±', '±'); | |
update wp_terms set name = replace(name, '²', '²'); | |
update wp_terms set name = replace(name, '³', '³'); | |
update wp_terms set name = replace(name, '´', '´'); | |
update wp_terms set name = replace(name, 'µ', 'µ'); | |
update wp_terms set name = replace(name, '¶', '¶'); | |
update wp_terms set name = replace(name, '·', '·'); | |
update wp_terms set name = replace(name, '¸', '¸'); | |
update wp_terms set name = replace(name, '¹', '¹'); | |
update wp_terms set name = replace(name, 'º', 'º'); | |
update wp_terms set name = replace(name, '»', '»'); | |
update wp_terms set name = replace(name, '¼', '¼'); | |
update wp_terms set name = replace(name, '½', '½'); | |
update wp_terms set name = replace(name, '¾', '¾'); | |
update wp_terms set name = replace(name, '¿', '¿'); | |
update wp_terms set name = replace(name, 'À', 'À'); | |
update wp_terms set name = replace(name, 'Ã', 'Á'); | |
update wp_terms set name = replace(name, 'Â', 'Â'); | |
update wp_terms set name = replace(name, 'Ã', 'Ã'); | |
update wp_terms set name = replace(name, 'Ä', 'Ä'); | |
update wp_terms set name = replace(name, 'Ã…', 'Å'); | |
update wp_terms set name = replace(name, 'Æ', 'Æ'); | |
update wp_terms set name = replace(name, 'Ç', 'Ç'); | |
update wp_terms set name = replace(name, 'È', 'È'); | |
update wp_terms set name = replace(name, 'É', 'É'); | |
update wp_terms set name = replace(name, 'Ê', 'Ê'); | |
update wp_terms set name = replace(name, 'Ë', 'Ë'); | |
update wp_terms set name = replace(name, 'ÃŒ', 'Ì'); | |
update wp_terms set name = replace(name, 'Ã', 'Í'); | |
update wp_terms set name = replace(name, 'ÃŽ', 'Î'); | |
update wp_terms set name = replace(name, 'Ã', 'Ï'); | |
update wp_terms set name = replace(name, 'Ã', 'Ð'); | |
update wp_terms set name = replace(name, 'Ñ', 'Ñ'); | |
update wp_terms set name = replace(name, 'Ã’', 'Ò'); | |
update wp_terms set name = replace(name, 'Ó', 'Ó'); | |
update wp_terms set name = replace(name, 'Ô', 'Ô'); | |
update wp_terms set name = replace(name, 'Õ', 'Õ'); | |
update wp_terms set name = replace(name, 'Ö', 'Ö'); | |
update wp_terms set name = replace(name, '×', '×'); | |
update wp_terms set name = replace(name, 'Ø', 'Ø'); | |
update wp_terms set name = replace(name, 'Ù', 'Ù'); | |
update wp_terms set name = replace(name, 'Ú', 'Ú'); | |
update wp_terms set name = replace(name, 'Û', 'Û'); | |
update wp_terms set name = replace(name, 'Ãœ', 'Ü'); | |
update wp_terms set name = replace(name, 'Ã', 'Ý'); | |
update wp_terms set name = replace(name, 'Þ', 'Þ'); | |
update wp_terms set name = replace(name, 'ß', 'ß'); | |
update wp_terms set name = replace(name, 'Ã ', 'à'); | |
update wp_terms set name = replace(name, 'á', 'á'); | |
update wp_terms set name = replace(name, 'â', 'â'); | |
update wp_terms set name = replace(name, 'ã', 'ã'); | |
update wp_terms set name = replace(name, 'ä', 'ä'); | |
update wp_terms set name = replace(name, 'Ã¥', 'å'); | |
update wp_terms set name = replace(name, 'æ', 'æ'); | |
update wp_terms set name = replace(name, 'ç', 'ç'); | |
update wp_terms set name = replace(name, 'è', 'è'); | |
update wp_terms set name = replace(name, 'é', 'é'); | |
update wp_terms set name = replace(name, 'ê', 'ê'); | |
update wp_terms set name = replace(name, 'ë', 'ë'); | |
update wp_terms set name = replace(name, 'ì', 'ì'); | |
update wp_terms set name = replace(name, 'Ã', 'í'); | |
update wp_terms set name = replace(name, 'î', 'î'); | |
update wp_terms set name = replace(name, 'ï', 'ï'); | |
update wp_terms set name = replace(name, 'ð', 'ð'); | |
update wp_terms set name = replace(name, 'ñ', 'ñ'); | |
update wp_terms set name = replace(name, 'ò', 'ò'); | |
update wp_terms set name = replace(name, 'ó', 'ó'); | |
update wp_terms set name = replace(name, 'ô', 'ô'); | |
update wp_terms set name = replace(name, 'õ', 'õ'); | |
update wp_terms set name = replace(name, 'ö', 'ö'); | |
update wp_terms set name = replace(name, '÷', '÷'); | |
update wp_terms set name = replace(name, 'ø', 'ø'); | |
update wp_terms set name = replace(name, 'ù', 'ù'); | |
update wp_terms set name = replace(name, 'ú', 'ú'); | |
update wp_terms set name = replace(name, 'û', 'û'); | |
update wp_terms set 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