Lets say you had written 50 posts and you write something incorrect. For example WordPress instead of WordPress. Now you can’t probably go look for all 50 posts to modify just the upper-case of P. In this post we will explain how you can use an SQL query for WordPress Database to Find and Replace written text with just one click.
First you need to connect to your Database.If you have a cPanel style hosting typically you will have an option to connect your Database via phpmyadmin.
Select your database and click SQL tab and run the following query:
update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME,'TEXT TO FIND','TEXT TO REPLACE
In this post we are replacing text WordPress to WordPress.
update wp_posts set post_content = replace(post_content,'Wordpress','WordPress')
This code will work for all MySQL databases not only for WordPress.Hit done and all will be replaced very easily but make sure to create your database backup before running this query.