Catch first img in post, remove it then associate to post as custom field?

Programming in sql: Catch first img in post, remove it then associate to post as custom field? on newest questions tagged sql – Stack Overflow

In my WordPress blog there are more than 500 posts.

Each post starts with small image.

I want to remove those small images from inside posts and display them as Custom Fields.

It will take me a long time to go through all posts and make the required change.

Is it possible to run a SQL query that will be able to:

1. Catch the small images.
2. Remove the small images from inside the post.
3. Associate small image to a post as a custom field.

source: http://stackoverflow.com/questions/11075493/catch-first-img-in-post-remove-it-then-associate-to-post-as-custom-field
Programming in sql: programming-in-sql