If you change domain with your blog, but decided to stick to the same database , probably you will have to update several URLs in your entries.
I’m a lazy person and everything which can be done automatically, will be be automated. Replacing links or words in your WordPress database table is a really simple act. Of course, you should first backup your database .
Open your CPanel or Plesk backend and move to the Database —> phpMyAdmin area. Select your database here and move to wp_posts
The syntax to replace strings/data/words/whatevah in your database is simple:
update tablename set field = replace(field,'search_for_this','replace_with_this');
In my case I had to change the URL from serialrecidivism.com; to ifranky.com/amifamousnow, the string looked as this:
update wp_posts set post_content = replace(post_content,'http://serialrecidivism.com','http://ifranky.com/amifamousnow');
Congratulations, after some Googling, you now have become a MYSQL authority!
