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 );
Related Posts:
- SQL Query to copy value of a meta_key into another meta_key
- How to correctly call custom field dates into a posts_where filter using SQL statements
- Add custom fields to search
- SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
- How to rename a custom field?
- Up/Down voting system for WordPress
- Custom Fields Bulk Edit
- Get all posts that do not have a specific custom field without using a subquery
- Order query by meta_value with multiple custom fields
- Custom Field Create Bulk via SQL Query
- UPDATE on SELECT results. A SQL query to swap Author with Meta Box value
- Saving Custom Field Data before Publish
- Meta Query And/Or
- Get emails from users by custom field SQL
- SQL: Select wordpress posts with given text string and add a custom field to them?
- Show array of meta_value in Edit Post Coloum
- Change word in woocommerce product category custom field
- SQL query to change the value of a Custom Field
- searching by keywords in post’s metas or pagination links problem
- Convert all dates in field to Unix time, except those already in Unix time
- How to Pull Out Twitter Summary Data in other areas of my template?
- query specific posts according their custom fields, using sql SELECT
- Alter SQL query to return posts with unique custom field value, no duplicate values
- Update field name without losing the value
- Advanced Custom Fields: how do I check to see if a value is set in an field? [closed]
- Add validation and error handling when saving custom fields?
- How to get custom post meta using REST API
- Is there any action filter/hook for validating a custom field before publishing the post?
- The “_encloseme” Meta-Key Conundrum
- Using get_post_meta with new_to_publish
- How to return Meta data from the REST API?
- Advanced Custom Fields – Get custom fields from parent page
- Get Post ID by Content
- Tabindex on text input immediately after WordPress title input
- How to access custom order item meta data from a meta key in WooCommerce?
- Display custom field value on woocommerce product page
- Display post_object content using Advanced Custom Fields plugin
- Remove old custom field after import
- Arrange custom fields with drag and drop?
- Allow user to create instances of custom field
- Saving Custom Field in Attachment Window in WordPress 3.5
- get_pages sort alphabetically by meta value
- Add custom field (value) to search result (without plugin)
- How to display multiple Post meta_key/meta_values by SQL query
- How to add a theme custom variable to a post title?
- 2 orderby in wp_query with 2 custom fields
- Check before publishing, if already exist post with current custom field value
- Copy SEO Meta Desc “Custom Field” to Excerpt field?
- Custom fields won’t display on my blog page
- How to customize default wordpress editor?
- Change content before writing to database
- post meta data clearing on autosave
- WordPress Search Custom Meta Field Only
- Order Custom post type loop by custom field (datepicker)
- Query Problem – Show posts within category ‘x’ that have a custom field between ‘y’ and ‘z’
- Localized Date Format for Custom Field
- Add an advert every nth Paragraph
- Add description text under input field for new profile fields
- Check if the value of a field has changed on save_post
- How to edit multiple post with Custom fields
- Undefined index error when saving content on metabox
- Which is best in the following scenario : post_meta vs custom table vs parent/child posts
- Saving custom image meta fields
- Echo values from custom field outside loop php
- How to update custom user meta field in wp?
- How to add content at the end of posts?
- Transfer self made functions.php custom fields to Advanced Custom Fields [closed]
- Complex WP_User_Query call fails on production server
- Query post order by post and desc not working
- If category then echo a custom fields
- How to query posts with certain custom meta data, and output Post data
- Custom Fields Not in Search Results
- How can I show custom fields in the loop only to specific user roles?
- Add conditional custom option to ‘Display name publicly as’ dropdown
- Custom fields not getting saved in the databse when added to the add new user profile page
- I want to send an email when each post is published
- Creating a widget with a number of custom fields
- Show 1 post and after a specific date show the next one
- How to Create Dynamic Fields in a Meta Box?
- Set front page option using custom fields?
- wordpress custom fields multiple data
- How do I define post titles as images using Custom Fields?
- How to show Small Box Inside Content Area, which holds (text, images, links)?
- Sort custom field by post
- How to order posts by one custom field and filter them by another one?
- Can we create a WordPress read-only virtual field derived from three other fields?
- Store array as single, serialized post meta field or many post meta fields?
- How to create a gallery custom field for WordPress post?
- Custom Field Values not updating unless I click “Update” twice
- Get an advanced custom field after post publish
- Why the pagination for a query modified by pre_get_posts doesn’t mind the number & order of posts sorted & selected based on a custom date time field
- How to display image inside container of custom made widget
- Trying to update_post_meta function
- Can I create a template or doctype for my blog site?
- Custom field, add class to anchor tag
- How do i add custom fields to my themes template file?
- Custom Field to a Role?
- List users by sum of all their posts’ custom field values
- Site uses wpdb to fetch meta_keys but just displays first meta_key from a page (the post uses the same meta_key “filmmaker” more than once)
- ACF auto complete all value from 1 cpt to another cpt