Bulk move (or copy) from a custom field to the post content?

Question

I need to move (or copy) the contents of a custom field into the main post body, replacing any existing content.

I need to do this for a few hundred posts...Is there a quick way of doing this?

I can manage moving values from one meta field to another in SQL, but i'm not sure how to do this with post content...

If anyone could give me some pointers that would be much appreciated.

Answer 1

For SQL, the post's content is saved in "wp_posts" table under "post_content" column. When doing this from phpmyadmin, you'll have to take care that you're updating only the main post & not one of it's revisions

If you're looking for some wordpress based solution, the wordpress way to do it is to use wp_update_post

// Update post 37
  $my_post = array();
  $my_post['ID'] = 37;
  $my_post['post_content'] = get_post_meta($my_post['ID'], 'meta_key', true);

// Update the post into the database
  wp_update_post( $my_post );