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'
)
)
)
