Update field name without losing the value

Question

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?

Thanks!

0
, , Johann 5 years 0 Answers 64 views 0

Leave an answer