From wordpress 3.0 version wordpress launched the feature called featured image. Many new wordpress themes are compatible with new wordpress version. So using or choosing the image as featured image for post is another manual work we need to do.
Many old wordpress website holder or blogger is having issue with this functionality. What they want is when they create the post they haven’t set the featured image, but they would like the featured image to default to the image that has been included in the post.
Some wordpress always use the first image as featured image but old post was not updated with featured image. They need to do manual work to set the featured image. I also faced same issue.
After doing some R&D I found the solution. If you want to set the your posts first image as featured image then use my following code.
For using the code you need to open your mysql database command prompt or phpmysqladmin program and select your wordpress database and execute the following query in that.
insert into wp_postmeta (meta_value, meta_key, post_id) select DISTINCT(ID), post_type , post_parent from wp_psts where post_type= 'attachment' and post_parent !=0 and post_status='inherit';<br /><br />update wp_postmeta set meta_key = '_thumbnail_id' where meta_key='attachment'
Using above sql query you will be able to set the featured image to your old and new post from post content. If you are having any issues with using this sql then write to me.
How to set post first image as featured image automatically
I Purab am from India, Pune. I am WordPress and Drupal Architect and consultant. I worked on many technologies like Ruby on Rails, Flex, PHP, jQuery etc...
Senior Technical Lead at Smartsourcing Global Pvt Ltd in Princeton, NJ, USA.
I contributed to many wordpress plugins and Drupal Modules. I contributed to Drupal core also.
Connect to purab on LinkedIn or
Follow @purab on Twitter or
Follow me on Google+ or
Write Mail to
Chat with me on Skype : purabdk