Skip to content

Instantly share code, notes, and snippets.

@robspangler

robspangler/wp-queries.sql

Last active August 29, 2015 14:22
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save robspangler/499d4116d61e94d4d92c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save robspangler/499d4116d61e94d4d92c to your computer and use it in GitHub Desktop.
Download ZIP
Common WordPress Queries
Raw
wp-queries.sql
// Update Image Path from Old to New Domain
UPDATE wp_posts SET post_content = REPLACE (post_content, 'src="http://OLDURL.com', 'src="http://NEWURL.com');
UPDATE wp_posts SET guid = REPLACE (guid, 'http://OLDURL.com', 'http://NEWURL.com') WHERE post_type = 'attachment';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment