1. Home »
  2. Tech

WordPress Search And Replace All Posts

WordPress

When managing a large WordPress website with a huge number of posts it will not be easy to change data inside each post. This would be a challenge especially if you want to change for example image links in all posts or replacing a certain tag in all your posts.

How To Search And Replace All WordPress Posts

  1. Go to your phpMyAdmin provided by your hosting provider phpMyAdmin cPanel
  2. Choose your desired WordPress database that you want to search and replace all its posts from the list WordPress database
  3. This will redirect you to all WordPress tables inside your database, choose the wp_posts table. WordPress posts table
  4. Press on the SQL tab from the top. WordPress phpMyAdmin SQL query
  5. Use the following SQL query to search and replace all your WordPress posts. Search and Replace all WordPress posts
UPDATE wp_posts SET post_content=(REPLACE (post_content, 'old','new'));

Don’t forget to change the word old with the data you want search. Also change the word new with the data you want to insert in your posts.

Share on Social Media

Related Posts

Fix WordPress 404 Error In All Pages And Posts
Fix WordPress 404 Error In All Pages And Posts
Who owns the Internet ?
Who owns the Internet ?
How to buy and own a website
How to buy and own a website
Fiat Chrysler Challenging Hackers
Fiat Chrysler Challenging Hackers
Guide how to verify your Facebook page with a blue tick
Guide how to verify your Facebook page with a blue tick
How To Transfer Your Domain Name To Another Company
How To Transfer Your Domain Name To Another Company

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *