- Log into your cPanel.
- Click on 'phpMyAdmin' in the 'Databases' section.
- Navigate to your database on left hand side of the page.
- Click on the table named 'wp_posts'.
- Click the 'Export' tab at the top of your page and backup the table 'wp_posts', just in case we make a mistake and need to revert.
- Click on the 'SQL' tab.
- The the 'Edit' link in the top right hand side of the screen.
- In the text field (the query field) input
MySQL | copy code | ? Note: This command will replace all the instances of the word 'rock' with the word 'tree' in all your posts and pages throughout your WordPress site. Replace the words 'rock' and 'tree' with the words you want to replace on your site.1 update wp_posts set post_content = replace(post_content,'rock','tree')
- Click the 'Go' button to have MySQL process the change.
