MySQL Search and Replace. Open your phpMyAdmin tool from your cPanel account. Navigate to the Database of your WordPress installation and select the `wpDbPrefix_posts` table. You should be able to see that the Column that we'll need to edit is called `guid` Click on the SQL tab on the top of your phpMyAdmin interface.