Skip to content

Instantly share code, notes, and snippets.

@nakov

nakov/select-replace.sql

Last active November 25, 2019 10:14
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 nakov/029affa8afefb2b87e4a08425fbb879d to your computer and use it in GitHub Desktop.
Save nakov/029affa8afefb2b87e4a08425fbb879d to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Find / Replace in the Database via SQL commands
Raw
select-replace.sql
SELECT REPLACE(post_title, " ", " ") FROM wp_posts
Raw
update-replace.sql
UPDATE wp_posts
SET post_title = REPLACE(post_title, " ", " ")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment