Skip to content

Instantly share code, notes, and snippets.

@jgwhite
Created December 6, 2011 14:00
Show Gist options
  • Select an option

  • Save jgwhite/1438301 to your computer and use it in GitHub Desktop.

Select an option

Save jgwhite/1438301 to your computer and use it in GitHub Desktop.
Sequel Pro WPURL Snippet
UPDATE wp_options SET option_value = REPLACE(`option_value`, '${1:}', '${2:}');
UPDATE wp_posts SET post_content = REPLACE(`post_content`, '$1', '$2');
UPDATE wp_posts SET guid = REPLACE(`guid`, '$1', '$2');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment