Hi and thank you for the suggestion, John.
What I did and solved my issue was using the following command:
UPDATE wpy4_postmeta SET meta_key= '_venue_custom_slider' WHERE (post_id = '29057' AND meta_value = 'field_582efaa778bfc' );
How did I do it in bulk? Good question. To get the ‘post_id’ (e.g. 29057) what I did was to:
1. Display all posts in the WP Admin > Posts area (Number of items per page: 999)
2. Filter by category (e.g. Venues)
2. Show Page Source
3. Copy/Paste the source code in the text editor (e.g. Atom)
4. Use the bulk search function (Find All) to search all my post IDs (e.g. ‘https://www.example.com/wp-admin/post.php?post=’ and selected only the string after that, next 5 digits in my case)
5. Paste that into an empty file, one on each row
6. Copy/Paste the mentioned MySQL command before and after the Post ID (using multi editing)
And the ‘meta_value’ I got it from ACF > Custom Fields > Field Groups > Field Keys (this column is hidden by default but can be shown easily from the Screen Options panel).
I hope that I remember the correct SQL command as I did finish the job the same day I posted here.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We've just released ACF 5.12.3 with a security fix to prevent arbitrary file uploads to forms with ACF fields.— Advanced Custom Fields (@wp_acf) July 14, 2022
Now that we've released this update, we recommend updating your sites as soon as possible.
© 2022 Advanced Custom Fields.