The only thing that I can think of here is that some of your posts contain single values and some contain arrays an possibly forms of values and not all the values have been updated.
You need to look, I’d look in the database and see what’s what and make sure I got everything updated.
as a work-around, but it will reduce query efficiency, you can use nested meta queries and check for a value either being exactly == or LIKE for each field.
'meta_query' => array( 'relation' => 'OR', array ( 'relation' => 'OR', array( 'key' => 'field_name_1', 'value' = $value_1 ), array( 'key' => 'field_name_1', 'value' = '"'.$value_1.'"' 'compare' => 'LIKE' ) ), array ( 'relation' => 'OR', array( 'key' => 'field_name_2', 'value' = $value_2 ), array( 'key' => 'field_name_2', 'value' = '"'.$value_2.'"' 'compare' => 'LIKE' ) ) )
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!
📣 “ACF Chat Fridays”— Advanced Custom Fields (@wp_acf) January 31, 2023
The ACF team holds their first open office hours this Friday! Come and talk ACF, and ask questions about building sites with the plugin.
We’d love to see you there!
📆 Friday 3rd Feb - 3pm UTC
👉 Register here - https://t.co/3UtvQbE4CU pic.twitter.com/oTwW9K1XQ0
© 2023 Advanced Custom Fields.