Get the Official WPSaviour App Now!

Best WordPress PluginsBlog

How To Delete Custom Field Values From WordPress Database

In case your WordPress weblog is outdated, you’ll discover plenty of customized subject meta_keys in your WordPress customized subject choices.

The issue with that is that you’ll see plenty of unused customized subject values which had been added by some outdated themes or plugins which you used a very long time in the past.

Here’s a screenshot of WPSaviour’s customized subject which has plenty of customized values (a lot of that are on account of outdated themes or plugins).

unused-custom-field

Now, when you use a customized subject so as to add values to your weblog submit, you’ll in all probability discover these ineffective meta_keys annoying.

On this submit, I shall be sharing how one can delete WordPress customized fields out of your database.

  • IMPORTANT: Do that course of at your personal threat. Ensure you take an entire backup of your WordPress database.

First, login to your phpMyAdmin account.

You need to use the WP-phpMyAdmin plugin to login out of your WordPress dashboard.

You can find this choice underneath Instruments > phpMyAdmin after you put in the WP-phpMyAdmin plugin.

As soon as you might be inside your WordPress dashboard, click on in your database and click on on “_postmeta” (on the left sidebar).

You will notice choices like meta_id, post_id, and meta_key.

You must see one thing like this screenshot:

meta_key Now choose “meta_key” and click on on the “browse” icon. (Consult with above screenshot.)

On the subsequent web page, you will notice all of your meta_key values together with the variety of rows utilized by them.

meta values

For instance, in above picture, the meta_key “articleimg” has 2 rows. Because of this that particular customized subject is utilized in two photos. Both I can discover these two posts or I can merely delete that worth from the database.

I’ll use the search subject to seek out these two values and can delete them from my WordPress database.

Click on on “Search”.

searchOn the subsequent web page, merely add the worth of the meta_key you want to seek for.

For instance, I’ll seek for “articleimg”:

search-meta-keyHit the “Go” button and now merely choose each values and delete them out of your database.

delete-values

This manner you’ll be able to eliminate all undesirable WordPress customized subject values and maintain your weblog database neat and clear.

I might counsel that you just solely carry out this process if you end up assured sufficient to take action. It’s not rocket science, however one fallacious click on may cause you plenty of problem.

I additionally counsel you attempt the Superior database cleaner plugin after this to scrub up your WordPress database even additional.

Download The WPSaviour App Now

Related posts
Beginner’s GuideBlogShowcase

7 Best Shopify Alternatives in 2020 (Cheaper and More Powerful)

Beginner’s GuideBest WordPress PluginsBlog

14 Best AI Chatbots Software for Your Website (Comparison)

Beginner’s GuideBlogTips

Magento vs WooCommerce – Which one is Better? (Comparison)

Beginner’s GuideBlogTips

12 Best Calculator Plugins for Your WordPress Site

Sign up for our Newsletter and
stay informed

Leave a Reply

Your email address will not be published.

Fear Of Missing Out?

Sign up with your email address to receive WordPress tips and updates
SUBSCRIBE NOW
Terms and Conditions apply
close-link
Click Me