How To Delete Custom Field Values From WordPress Database

By WP Saviour •  Updated: 01/24/21 •  3 min read

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).

unusedcustomfield_thumb-6916331

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.

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_thumb-9010618 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.

metavalues_thumb-6383139

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”.

search_thumb-6286048On the subsequent web page, merely add the worth of the meta_key you want to seek for.

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

searchmetakey_thumb-7400286Hit the “Go” button and now merely choose each values and delete them out of your database.

deletevalues_thumb2-8614198

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.

gp-4153056 as-6295705

WP Saviour

I am a WordPress specialist. My mission is to help you create beautiful websites with ease!