Skip to content

Instantly share code, notes, and snippets.

View mmizwicki's full-sized avatar

mmizwicki

1 follower · 2 following
View GitHub Profile
@mmizwicki
mmizwicki / character-cleanup.sql
Last active January 3, 2016 10:38 — forked from ramseyp/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, '•', '-');