I hope I understand the question correctly
UPDATE `wp_postmeta` SET `meta_value` = replace(meta_value, 'old_value', 'new_value') WHERE `meta_key` LIKE 'your_key'
EDIT 1 : i forgot to mention : BACKUP YOUR DATABASE BEFORE ANY TRIAL
EDIT 2 : following comment : To copy from one field to another (I got a bit confused with your naming and which value you want where , so I post the generic sentence.
UPDATE `TABLE` SET `FIELD2` = `FIELD1'
Related Posts:
- Advanced Custom Fields: how do I check to see if a value is set in an field? [closed]
- Where are custom field values stored in the database
- 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
- Advanced Custom Fields – Get custom fields from parent page
- Add custom field to the archive page?
- 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?
- Matching Serialized Arrays with meta_query
- How to position a custom field before the editor
- Display post_object content using Advanced Custom Fields plugin
- Remove old custom field after import
- Unable to get Preview of Uploaded image within a Custom Meta box
- Retrieve custom fields on Categories, using WP-API
- Order by custom field date?
- Bulk move (or copy) from a custom field to the post content?
- Up/Down voting system for WordPress
- Change content before writing to database
- Order Custom post type loop by custom field (datepicker)
- Using Custom Function With Advanced Custom Fields
- automatically set “Featured Image” the same as the og:i that is set in a custom field
- Problem with adding exta field in metabox in custom post type
- Copying Custom Meta Values from existing post to a duplicate post
- Displaying Custom Fields on Post with Genesis Child Theme
- Unable to show ACF’s Image Custom Field properly in Genesis Framework [closed]
- Show ACF fields only on certain page in the backend
- Update posts after populating ACF field value [closed]
- How can I pass a variable set by ACF to header.php?
- WP Custom Fields Metabox Disappears – ACF plugin issue [closed]
- Get all posts that do not have a specific custom field without using a subquery
- Transfer self made functions.php custom fields to Advanced Custom Fields [closed]
- Order query by meta_value with multiple custom fields
- How To Fix WP Query Returns Results But Shouldn’t?
- Will loading too many ACF Fields cause slow down?
- WP_User_Query pulling ACF to loop
- Calling the “wp-link-wrap” pop-up modal
- How to add Advenced Custom Fields In Single Post
- How to schedule a custom field value update?
- Add new image block, set default class name and update it using Javascript
- Get an advanced custom field after post publish
- How to create a dropdown select of all items in an ACF field group
- Advanced Custom Fields dynamic update_field
- WooCommerce – Adding Custom Fields To Invoice
- Sort custom post type by multiple custom fields
- Meta Query And/Or
- Advanced Custom Fields WYSIWYG More tag
- Walker class for sub-menu with ACF fields
- How to list Category list in ACF Pro’s Select Field to choose from [closed]
- Get all the posts where meta field with multiple choice has several values checked
- Custom fields issue [closed]
- Querying posts by latitude and longitude to build a Google Maps with several markers
- ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
- ul list with only as many li’s as filled custom fields
- Get emails from users by custom field SQL
- Retrive Image URL of Custom Fields in Theme
- Display custom field from the front page on another page
- Let Users Filter Posts by Custom Fields
- Filter posts by custom field (Advanced Custom Fields)
- How can I output the custom fields wrapping with HTML
- Displaying an ACF list of users
- The conditional logic only works to show or hide?
- ACF Plugin How to make the customer add more fields in the post?
- Custom field Search with Relavanssi
- How to get custom image field of specific post id
- Show array of meta_value in Edit Post Coloum
- Need to search a custom field (ingredients, one long string per post), but want it to allow phrases/non-exact matches
- How To Save Data From Remote APIs To ACF?
- comments_where Hook
- How to show ACF fields in Gridbuilder custom block
- Change word in woocommerce product category custom field
- Problem with revisions only returning four results
- How to set up page fields with gutenberg instead of ACF
- ACF multi taxonomy on filterable gallery
- Is there any way to make a custom field for a post only if the author is a certain user?
- How to use ACF with javascript to update custom field values?
- SQL query to change the value of a Custom Field
- adding autosave feature to custom fields
- searching by keywords in post’s metas or pagination links problem
- Getting user’s data, by custom field lookup (meta)
- ACF – Compare user and post data
- Counting number of images from loop
- How to add content with a filter when there’s no content in the editor
- Advanced Custom Fields from Category – IF statement
- Query Posts based on custom field value
- Using ACF Custom Field value in a URL with do_shortcode() [closed]
- Display Child Page with custom fields within Parent Page
- Filter and display a specific custom field value [closed]
- Convert all dates in field to Unix time, except those already in Unix time
- Display different category template if custom field is checked
- Fetch data from a WP page with same name as current username
- Alter SQL query to return posts with unique custom field value, no duplicate values
- Adding custom field to an array
- Add image custom attribute [closed]
- Truncating characters in Advanced Custom Fields works some places but not others?
- save all acf options in one meta_value [closed]
- Conditional display based on ACF checkbox
- How to add an ACF only for parent term?
- Best way for managing images of ads banners
- ACF in radio button cf7