Hi, All. Today I moved to new blog, my blog’s old posts content moved to new blog. and updated all URLs in simple way. Here is SQL Query.
UPDATE wp_posts SET post_content = replace(post_content, 'http://oldurl.com', 'http://mynewblog.com');
- Just got to your blog’s SQL admin page, Here i am using phpMyAdmin.
- so login to your blog’s database.
- Then select your blog’s database.
- Then SQL tab to enter SQL Query. just type the above sql query into query box.
- then select go button.
So, single click to replacing old URLs to new URLs in blog post’s content is so simple and easy.