Replace/Remove Content From Mysql In Wordpress..!
 |
If you have enough idea regarding Mysql thats ok, but if you are new to this Wordpress and Mysql bla bla.., but if you have some 800 posts in your wordpress database, and you need to change any text or url in all the posts is tedious job and we can’t do this in fact. Hear is the following solution that you can replace any text or urls from MySql database, that to if you are using wordpress some times we may face permalinks problem, hear we have to change any url to some other or we have to remove or replace the part of the link in that times this tutorial will help you a lot.
Replace/Remove Content From Mysql:
- Open your phpMyAdmin,
- Click on SQl tab in the top right,
- Enter the following in the run SQL Query text box.
UPDATE wp_posts SET post_content = REPLACE ( post_content, 'text to be replaced', 'replacement text' );
- Now click on Go button for the changes to be take place.
- That’s it you are done..!
In the abouve systax.., you can replace not only form wp_posts, also form wp_”some thing” in your wordpress database, enjoy.
You May Also Like
Get Updates:
| |
I never try play with Mysql. Good info.
Hi Abhi,
Mysql is worlds popular database, this might difficult to see but we can play with that.
Good journey and experience!
Whenever i see the post like your’s i feel that there are still helpful people who share information for the help of others, it must be helpful for other’s. thanx and good job.
Comment Edited
Please don’t mention any URL’s in the comments…!
@team str
Thank you..!
——————————————————————————————
Hello friend,
With out knowing any knowledge regarding Database, it is better to not do any experiments.
Replace/Remove content from Mysql database is a little bit tedious job, we should take care on this, we are giving these type of tutorials only in extension conditions.. so the posts we are providing are 100.1% secure,
Enjoy the site
Thanks for sharing your comments.
This is an interesting article. Thanks for sharing.
You are always welcome my dear friend..
Awesome! Thanks for the tip, it was really helpful!
You always welcome my friend