Remove all featured images from posts Tutorial

To be honest, there are many WordPress plugins that solves user problem and gives rise to other problems. I have been using WordPress CMS since 4-5 months and i’ve tried 100′s of plugins on this blog. Some plugins landed me and my blog in trouble and some were very useful for me (i won’t name the plugins in this context). One such plugin that landed me in a trouble is the plugin to set featured images for all my WordPress posts automatically.The featured images plugin did the job for me, but when i wanted to remove the images from the posts, the plugin had no feature to do so. The featured post that the plugin set didn’t look that great on my free WordPress theme.In other words, my blog looked terrible with featured images…hence, i had to remove them from my posts. As the featured image plugin didn’t have any option to rollback the update it did to every posts, i explored the internet to find the possible solution to my problem. After exploring an hour and finding no solution to my problem. . i decided to solve the problem by myself. Being a programmer myself, i knew that the problem can be solved by deleting the database entry for WordPress posts featured images/ thumbnails.
Tutorial to remove all featured images from posts

To delete the database table entry for featured images, i wrote a simple query and fired it. (Make sure that you backup the database before you fire the below query.

delete FROM post_meta WHERE `meta_key`=’_thumbnail_id’

To execute a database query

1. Note down your database name, user name and its password from the wp-config file.
2. loginto your phpmyadmin account with the username and the password (Every hosting company provides the access to phpmyadmin)
3. For those who have no idea about it, phpmyadmin is a GUI that gives you the power to access mysql databases from your webbrowser. With phpmyadmin, you can easily browse your database tables or execute an MYSQL query.
4. Once you log into the phpmyadmin, click on your websites database (the database name that you had noted in step 1.
5. When you click on your websites database link, in the left your screen you’ll be able to see all the tables of your WordPress websites database.
6. From the list, click on the database table named postmeta.
7. Once you click on the post meta table, in the center of the screen you’ll be able to see various tabs and first 30-40 rows of the postmeta table.
8. From the list of the tabs that you see, click on SQL to open a text area where you can write or execute queries.
9. copy the query to remove featured images from all the posts and paste it the sql text area. Now click on the Go button.
10. Now you’ll see a small dialog box with 2 buttons Ok and cancel.
11. Click on the ok button.
12. Done

Now logoff the phpmyadmin to kill the session.

Now browse your website. . there would be no featured images for posts.