Skip to content

Instantly share code, notes, and snippets.

@rmpel

rmpel/remove-sep.sql

Created May 15, 2018 08:40
Show Gist options
  • Save rmpel/590067510e2ad7a092a26d8f2344ca30 to your computer and use it in GitHub Desktop.
Save rmpel/590067510e2ad7a092a26d8f2344ca30 to your computer and use it in GitHub Desktop.
Download ZIP
Remove LSEP from database
Raw
remove-sep.sql
update wp_posts SET post_title = REPLACE(post_title, UNHEX('e280a8'), '') WHERE post_title LIKE concat('%', UNHEX('e280a8'), '%');
update wp_posts SET post_content = REPLACE(post_content, UNHEX('e280a8'), '') WHERE post_content LIKE concat('%', UNHEX('e280a8'), '%');
@marcelo2605
Copy link

Thank you!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment