Replace String in Table using SQL

Using SQL to change multiple entries in a database table can be more efficient than editing each entry with phpMyAdmin.

A customer had developed a replacement website in Wordpress. This was to subsequently become the main website with the entries for the developemtn URL to be replaced by the active site URL. I began by using phpMyAdmin to change some of the entries. This also showed that the website was too large to reasonably proceed in this way.

Using the SQL code below I was able to change the references in the posts table from the development to the active URL.

UPDATE wp_posts SET guid = REPLACE(guid,"devurl.co.uk","activeurl.co.uk")

NAT August 2009