Category: MySQL

UPDATE wp_posts SET post_content = REPLACE(post_content, ‘“’, ‘“’); UPDATE wp_posts SET post_content = REPLACE(post_content, ‘†‘, ‘”’); UPDATE wp_posts SET post_content = REPLACE(post_content, ‘’’, ‘’’); UPDATE wp_posts SET post_content = REPLACE(post_content, ‘‘’, ‘‘’); UPDATE wp_posts SET post_content = REPLACE(post_content, ‘—’, ‘–’); UPDATE wp_posts SET post_content = REPLACE(post_content, ‘–’, ‘—’); UPDATE wp_posts SET post_content = REPLACE(post_content,… Continue reading Remove weird characters from a database