If your WordPress blog is old, probably you will notice lots of custom field meta_key in your WordPress custom field option. The problem with this is that you will see lots of unused custom field values which is added by some old theme or by plugin which you used long time back.
Here is a screenshot of ShoutMeLoud custom field which has lots of custom value and many of them are because of old theme or plugin.
Now if y0u use custom field to add values to your blog post, probably you might find those useless meta_keys annoying.
In this post, I will be sharing how you can delete WordPress custom field from database. Though you need to make sure that you do this process with your own risk & don’t forget to take a complete backup of your WordPress blog database.
Login to your phpmyadmin. You can use wp-phpmyadmin plugin to login from your WordPress dashboard. You will find option under tools> phpmyadmin after you installed wp-phpmyadmin plugin.
Once you are under your WordPress dashboard, click on your database and click on _postmeta (left sidebar). You will see options like meta_id, post_id, meta_key . Something like this screenshot:
For example, in above image, meta_key articleimage has two rows. This means that custom field is used in two image. Either I can find those two post or I can simply delete that value from database.
I will use the search field to find those two values and will delete it from my WordPress database.
Click on search on the same page and you might like to open it in a new tab.
This way you can get rid of all unwanted WordPress custom field values and keep your blog neat and clean. Though I would suggest perform this task only when you are confident enough. It’s not rocket science but one wrong click can cost you lots of hassle.
I also suggest you to try clean options WordPress plugin after this to clean your WordPress database.
I hope you find this tutorial easy to understand, if you have any questions, feel free to ask via comments. If you liked this post, don’t forget to share on Facebook and stumble upon.
Check your domain ranking