Your question should be specific to WordPress. Generic PHP/JS/SQL/HTML/CSS questions might be better asked at Stack Overflow or another appropriate Stack Exchange network site. Third-party plugins and themes are off-topic for this site; they are better asked about at their developers' support routes.

Closed 4 years ago.

I have conent located in a custom field named main_content in wp_postmeta and need to copy that content to post_content in wp_posts. There are about 400 posts and have no sql background but should be pretty easy I think, just not sure on the right code?

SELECT * FROM `wp_postmeta` WHERE `post_id` IS main_content AND INSERT INTO wp_posts WHERE `post_id` IS `post_content`

Something like above but not sure if that is correct