Update field name without losing the value
So I have this photography website using ACF with flexible content. It has approximately 300 posts. Due to requirements, I need to update the name of some fields.
I’ve tried the following query:
UPDATE wp_postmeta SET meta_key = 'content_0_left_col_image_' WHERE meta_key = 'content_0_left_column_image'; UPDATE wp_postmeta SET meta_key = '_content_0_left_col_image_' WHERE meta_key = '_content_0_left_column_image';
Rows are affected (so everything’s updated) but when I go ahead and try view any of the existing posts, the data inside that field is gone.
Any ideas what could be wrong?