character-cleanup.sql

## Run this in phpMyadmin
##
## Cleans up Posts table
UPDATE wp_posts SET post_content = REPLACE(post_content, '“', '“');
UPDATE wp_posts SET post_content = REPLACE(post_content, '”', '”');
UPDATE wp_posts SET post_content = REPLACE(post_content, '’', '’');
UPDATE wp_posts SET post_content = REPLACE(post_content, '‘', '‘');
UPDATE wp_posts SET post_content = REPLACE(post_content, '—', '–');
UPDATE wp_posts SET post_content = REPLACE(post_content, '–', '—');
UPDATE wp_posts SET post_content = REPLACE(post_content, '•', '-');
UPDATE wp_posts SET post_content = REPLACE(post_content, '…', '…');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'Â', '');
UPDATE wp_posts SET post_content = REPLACE(post_content, 'é', 'é');
 
##
##
## Cleans up Posts Title
##
UPDATE wp_posts SET post_title = REPLACE(post_title, '“', '“');
UPDATE wp_posts SET post_title = REPLACE(post_title, '”', '”');
UPDATE wp_posts SET post_title = REPLACE(post_title, '’', '’');
UPDATE wp_posts SET post_title = REPLACE(post_title, '‘', '‘');
UPDATE wp_posts SET post_title = REPLACE(post_title, '—', '–');
UPDATE wp_posts SET post_title = REPLACE(post_title, '–', '—');
UPDATE wp_posts SET post_title = REPLACE(post_title, '•', '-');
UPDATE wp_posts SET post_title = REPLACE(post_title, '…', '…');
UPDATE wp_posts SET post_title = REPLACE(post_title, 'Â', '');
UPDATE wp_posts SET post_title = REPLACE(post_title, 'é', 'é');


##
##
## Cleans up Posts Excerpt
##
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, '“', '“');
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, '”', '”');
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, '’', '’');
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, '‘', '‘');
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, '—', '–');
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, '–', '—');
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, '•', '-');
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, '…', '…');
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, 'Â', '');
UPDATE wp_posts SET post_excerpt = REPLACE(post_excerpt, 'é', 'é');
 
##
##
## Cleans up Comments
##
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '“', '“');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '”', '”');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '’', '’');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '‘', '‘');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '—', '–');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '–', '—');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '•', '-');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, '…', '…');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, 'Â', '');
UPDATE wp_comments SET comment_content = REPLACE(comment_content, 'é', 'é');
 
##
##
## Cleans up User Meta (descriptions)
##
UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, '“', '“');
UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, '”', '”');
UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, '’', '’');
UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, '‘', '‘');
UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, '—', '–');
UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, '–', '—');
UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, '•', '-');
UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, '…', '…');
UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, 'Â', '');
UPDATE wp_usermeta SET meta_value = REPLACE(meta_value, 'é', 'é');