How to change acf wordpress key name?

Question

MySQL

Hello!
There is a bunch of wordpress site , acf custom fields plugin and mysql database .
I plan to replace some acf key names so as not to lose the information written in these fields.


I do according to the instructions

UPDATE `wp_postmeta` as m JOIN `wp_posts` as p ON m.post_id = p.ID SET m.meta_key = '_new_field_name' WHERE m.meta_value = 'field_5af0d933478b4' AND p.post_type = 'post'

But, my post_type can have post, page, custom post, options page. As a result, I get such a history that the name of the key itself has changed, but the key-value binding has remained the same. How to win?

Answer 1

AND p.post_type IN ('post','page','custom post','options page')