Skip to content

Instantly share code, notes, and snippets.

@cfaria

cfaria/update_table.sql

Created April 25, 2014 09:45
Show Gist options
  • Save cfaria/11283921 to your computer and use it in GitHub Desktop.
Save cfaria/11283921 to your computer and use it in GitHub Desktop.
Download ZIP
Replace text in a table
Raw
update_table.sql
UPDATE wp_posts SET post_content= REPLACE (post_content, '/temp/', '/blog/') WHERE post_content like '%/temp/%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment