Update field name without losing the value

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:

  1. Advanced Custom Fields: how do I check to see if a value is set in an field? [closed]
  2. Where are custom field values stored in the database
  3. SQL Query to copy value of a meta_key into another meta_key
  4. How to correctly call custom field dates into a posts_where filter using SQL statements
  5. Advanced Custom Fields – Get custom fields from parent page
  6. Add custom field to the archive page?
  7. Add custom fields to search
  8. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  9. How to rename a custom field?
  10. Matching Serialized Arrays with meta_query
  11. How to position a custom field before the editor
  12. Display post_object content using Advanced Custom Fields plugin
  13. Remove old custom field after import
  14. Unable to get Preview of Uploaded image within a Custom Meta box
  15. Retrieve custom fields on Categories, using WP-API
  16. Order by custom field date?
  17. Bulk move (or copy) from a custom field to the post content?
  18. Up/Down voting system for WordPress
  19. Change content before writing to database
  20. Custom Fields Bulk Edit
  21. Order Custom post type loop by custom field (datepicker)
  22. Using Custom Function With Advanced Custom Fields
  23. automatically set “Featured Image” the same as the og:i that is set in a custom field
  24. Problem with adding exta field in metabox in custom post type
  25. Copying Custom Meta Values from existing post to a duplicate post
  26. Calculate the sum of certain the_sub_fields
  27. Displaying Custom Fields on Post with Genesis Child Theme
  28. Unable to show ACF’s Image Custom Field properly in Genesis Framework [closed]
  29. Login & Register & Custom details WITHOUT plugin
  30. Send Multiple Custom Field Values Through the URL
  31. ACF won’t load from a custom JSON location
  32. Show ACF fields only on certain page in the backend
  33. Update posts after populating ACF field value [closed]
  34. How can I pass a variable set by ACF to header.php?
  35. WP Custom Fields Metabox Disappears – ACF plugin issue [closed]
  36. Get all posts that do not have a specific custom field without using a subquery
  37. Transfer self made functions.php custom fields to Advanced Custom Fields [closed]
  38. Order query by meta_value with multiple custom fields
  39. ACF: How to get the full field name (meta_key) by a field key?
  40. How To Fix WP Query Returns Results But Shouldn’t?
  41. Dynamically fill a post custom field with post publish date
  42. How can I store a file in the database in the same way WordPress and ACF do?
  43. Will loading too many ACF Fields cause slow down?
  44. Custom Field Create Bulk via SQL Query
  45. WP_User_Query pulling ACF to loop
  46. Calling the “wp-link-wrap” pop-up modal
  47. Print custom field in Query Loop block
  48. How to add Advenced Custom Fields In Single Post
  49. How to schedule a custom field value update?
  50. Order RSS content by an advanced custom field value
  51. Add new image block, set default class name and update it using Javascript
  52. Get an advanced custom field after post publish
  53. How to create a dropdown select of all items in an ACF field group
  54. Advanced Custom Fields dynamic update_field
  55. WooCommerce – Adding Custom Fields To Invoice
  56. UPDATE on SELECT results. A SQL query to swap Author with Meta Box value
  57. Sort custom post type by multiple custom fields
  58. Meta Query And/Or
  59. Vimeo thumbnails
  60. Advanced Custom Fields WYSIWYG More tag
  61. Walker class for sub-menu with ACF fields
  62. How to list Category list in ACF Pro’s Select Field to choose from [closed]
  63. Get all the posts where meta field with multiple choice has several values checked
  64. Custom fields issue [closed]
  65. Querying posts by latitude and longitude to build a Google Maps with several markers
  66. ACF: How to get users with a ACF flexible content subfield with a specific value AND layout?
  67. How to copy data from a custom field to the post_content?
  68. WordPress creates new lines in postmeta table on post update
  69. ul list with only as many li’s as filled custom fields
  70. Get emails from users by custom field SQL
  71. Retrive Image URL of Custom Fields in Theme
  72. Display custom field from the front page on another page
  73. How to Pass values to Custom Field through PHP in WordPress Posts?
  74. Let Users Filter Posts by Custom Fields
  75. Filter posts by custom field (Advanced Custom Fields)
  76. Advanced Custom fields not available yet during publish_page action
  77. How can I output the custom fields wrapping with HTML
  78. How to filter post using custom feild value in shortest and longest duration?
  79. Query Posts Via WordPress URL
  80. How to Order Posts by Custom Fields?
  81. Fetch data from a WP page with same name as current username
  82. query specific posts according their custom fields, using sql SELECT
  83. Get custom field from other post in carousel
  84. I want to add a custom field in the rss title of each post, but don’t want it to be shown on the site
  85. Alter SQL query to return posts with unique custom field value, no duplicate values
  86. Advenced custom fields auto fill problem
  87. Adding custom field to an array
  88. Add image custom attribute [closed]
  89. How to get all specific fields from one ACF Group?
  90. Truncating characters in Advanced Custom Fields works some places but not others?
  91. save all acf options in one meta_value [closed]
  92. Conditional display based on ACF checkbox
  93. acf field repeater link don’t work
  94. How to add an ACF only for parent term?
  95. Best way for managing images of ads banners
  96. ACF in radio button cf7
  97. How to conditionally display an ACF custom textarea contents only to those users chosen from an ACF User field
  98. Populate Elementor Form based on first selection
  99. SQL query based on two different custom field values
  100. Displaying child pages and file URL in an ACF relationship field shortcode
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)