Code To Replace Embedded Post Links After Changing Domain Name In WordPress Blog?

Hi,

Whenever we have changed domain name then we need to change the embedded link to absolutre path with old domain name. To overcome from this situation and change/edit all the post…we need to execute this query on database:

update `wp_BLOGID#_posts`
set `post_content` = replace(`post_content`,’olddomain.com’,’newdomain.com’)

The posts table of particular blog, change all instance of olddomain.com to newdomain.com. make sure we use right blog ID of the blog in question.

Thanks,

Shane G.

Popularity: 3%