- Log into your cPanel interface.
- Once inside the cPanel, find the Databases category and click on the phpMyAdmin tool icon.
- You are now on the main phpMyAdmin page. Find the newly added database and click on its name from the left-hand sidebar.
- This opens the database and the screen refreshes with a list of the tables. Using the sidebar again, find and click on the wp-posts table.
- Look to the top of the screen and you will see several tabs that run across the page. Click on the SQL tab.
- You are now on a MySQL editor screen. In the code area, copy the following bit of MySQL.
UPDATE wp_posts SET post_content=(REPLACE (post_content, ‘<old url>’,'<new url>’));