Advanced Search

Return to Snippet

Revision: 50415
at August 20, 2011 00:59 by S_Park
Initial Code 
UPDATE wp_posts SET guid = replace(guid, "dev.domain.co.uk", "www.domain.co.uk")
Initial URL 









Initial Description





Useful for when moving a Wordpress installation from, e.g., development to live. 'wp_posts' is the table name, 'guid' is the table field. Alter as appropriate.









Initial Title





Wordpress SQL Find & Replace









Initial Tags














Initial Language





SQL