Replace Text in Post Topic via MySQL Database in WordPress

Most of the wordpress user find Elive Net  it is difficult to replace a single word in thousands of post so let me make it simple for you all so that you can save your time and finish it in a short moment.The fastest way to replace a text in WordPress is PHP Mysql and moreover it provides the fastest server.today I am going to help you by teaching how to replace a line or sentence or a word via a simple query.

Why a user required this type of Query ?

1. Massive import of topics from other blogs

2. Migration from one domain to other with the same data files

3. By default you have placed automatic keyword to the post topic.

Warning :- Some precaution you need to keep backup of databse before running this query as this might make corruption in the Database.

Let me begin with the process :-

Step 1. If you can access Cpanel then go to Cpanel then Msql Database

Step 2. Select your Database

Step 3. Select SQL option in the upper side

msql

Step 4. Now in the box put the below Words to search and replace :-

UPDATE wp_posts SET post_content = REPLACE (
post_content,
'Item to replace here',
'Replacement text here');

Explanation :-

wp_posts = Posts data
You need to replace :- Item to replace here with your desired word or words
You need to replace :- Replacement text here which will be override the previous word

Similarly If you want to replace the title then you can run the following query :-

UPDATE wp_posts SET post_title = REPLACE (
post_title,
'Item to replace here',
'Replacement text here');

Thats It,Now check your Posts as it removes the Words !

Author: Rohit Shetty

Share This Post On