Skip to content

Instantly share code, notes, and snippets.

@yayMark

yayMark/bad_encode_to_html_entity.sql

Created December 6, 2017 03:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yayMark/afa40180ab54dd62bf5f822fbb8ecbba to your computer and use it in GitHub Desktop.
Save yayMark/afa40180ab54dd62bf5f822fbb8ecbba to your computer and use it in GitHub Desktop.
Download ZIP
WordPress: find and replace badly encoded characters with HTML encoded versions
Raw
bad_encode_to_html_entity.sql
update wp_posts set post_content = replace(post_content,'“','“');
update wp_posts set `post_excerpt` = replace(post_excerpt,'“','“');
update wp_postmeta set meta_value = replace(meta_value,'“','“');
update wp_posts set post_content = replace(post_content,'’','’');
update wp_posts set post_excerpt = replace(post_excerpt,'’','’');
update wp_postmeta set meta_value = replace(meta_value,'’','’');
update wp_posts set post_content = replace(post_content,'–','—');
update wp_posts set `post_excerpt` = replace(post_excerpt,'–','—');
update wp_postmeta set meta_value = replace(meta_value,'–','—');
update wp_posts set post_content = replace(post_content,'‘','‘');
update wp_posts set `post_excerpt` = replace(post_excerpt,'‘','‘');
update wp_postmeta set meta_value = replace(meta_value,'‘','‘');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment