Reply To: WP Archive page with filter (key=array, value=array)

• John Huebner

• June 8, 2020 at 12:05 am

You need to create a sub query in the meta query

$sub_query = array('relation' => 'OR');
foreach ($colors as $color) {
  $sub_query[] = array(
    'key' => 'project_color',
    'value' => '"'.$color.'"',
    'compare' => 'LIKE'
  }
}
$meta_query[] = $sub_query;

You may still run into issues. If some of your posts have values stored the old way then this will not work since the values are probably not stored as arrays.

Also if your list of colors to look for gets too large the number of “LIKE” queries could time out the DB request.