/ Published in: SQL
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.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
UPDATE wp_posts SET guid = REPLACE(guid, "dev.domain.co.uk", "www.domain.co.uk")