Clean Your WordPress Database

Run the following SQL to clean up the content in your posts and comments:

UPDATE e1tips_posts SET post_content = REPLACE(post_content, '“', '"');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '”', '"');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '’', '\'');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '‘', '\'');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '—', '–');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '–', '—');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '•', '-');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '…', '…');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '“', '"');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '”', '"');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '’', '\'');
UPDATE e1tips_posts SET post_content = REPLACE(post_content, '‘', '\'');

UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '“', '"');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '”', '"');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '’', '\'');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '‘', '\'');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '—', '–');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '–', '—');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '•', '-');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '…', '…');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '“', '"');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '”', '"');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '’', '\'');
UPDATE e1tips_comments SET comment_content = REPLACE(comment_content, '‘', '\'');