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
- Apply the_content filter to a custom field with multiple values
- Meta Query with AND & OR?
- Adding another state (spam, reject, approve) to wordpress comments?
- WP doesn’t show Array Custom Fields?
- Filter archive.php by custom meta
- How do I search an array stored in a custom-field using WP_Query?
- Get updated meta data after save_post hook
- Custom text-only header
- Plugin to auto convert custom fields to tag
- Order by Custom Field date not recognized
- How do I read the value of a custom field of the page?
- Display custom field only if value present?
- Advice needed for importing custom field data and database structure
- How to save multiple metaboxes?
- Displaying additional User Contact Information
- get_post_meta in sitewide tags plugin fails to return value for custom fields
- Populate Custom Field Dropdown on Theme Install?
- WooCommerce conditional required checkout fields [closed]
- Make URL in custom field hyper link
- meta query not showing any results?
- Using more than one meta_key in pre_posts_query
- Way To Store Global Meta Values
- Creating a custom menu/widget area
- Can’t get post ID using wp_insert_post_data
- query usermeta from custom field
- Creating author profiles with extra fields and exporting that data?
- Modifying custom order item meta from admin order view
- Let users track progress by entering a number daily in profile?
- WooCommerce – Adding Custom Fields To Invoice
- Changing themes… and need to move Custom Field content into another field
- Filter Posts on Custom Fields and Show them on a new Page
- Removing link ” from ” on meta_value in custom feilds
- How to add a custom field in the advanced menu properties?
- $form_fields from attachment_fields_to_edit returning empty array
- How to link keywords in custom fields?
- Meta query with multiple custom fields for archives page ordering problem
- filter custom field values $min $max
- Adding custom field to post object from custom table
- Auto embeding Vimeo/Youtube in custom fields (tinyMCE editor)
- How do I use “if field exists” with $curauth?
- Using abs() with custom field in orderby statement
- Can’t save custom field on registration page
- Read more to open external link
- Custom metabox not displaying multiselect data in edit mode
- How to validate select field in post meta?
- check for duplicate user meta data before updating
- WP Cli – post add meta in xargs after wp post generate – add multiple fields
- Anyone know how to use ACF and show custom fields for logged in users only on a post? [closed]
- How to redirect to home page according to a specific page custom fields value and user name
- How to use pre_get_posts to alter posts_per_page of category pages, where ‘posts_per_page’ will be dynamic
- How to print the Custom fields values [closed]
- How to validation for sanitize_URL?
- How can I output the custom fields wrapping with HTML
- Custom metabox not working
- How to get custom image field of specific post id
- Populate wordpress menu with link to custom field value (file download)
- Selectively hiding or allowing thumbnails of featured images on front page
- wp_get_attachment_image_src() with advanced custom fields returning empty
- Woocommerce products search with custom fields
- Convert author metadata to a custom field
- Saving Custom Field that includes Quotation marks
- how to execute custom field for structured data?
- Saving custom form data
- register_form, custom field not submitted on first try
- Echo out custom fields in comments
- Why WordPress takes time to make request to save post?
- Show comon custom field results?
- Filter query based on date in custom field
- Display Child Page with custom fields within Parent Page
- get_post_custom_values not working
- Show div based on custom meta value
- add multiple values (array) to post meta_input
- Assign class to Drop Down Selections in WooCommerce Products Custom Fields
- Show/Hide Featured Image or replace it with custom field [closed]
- Multiple permalinks for a single post from custom field
- Search for meta_query does not return any result if combined with title