I am allowing users to query posts using a form with checkboxes. I want the posts to be filtered by the checkboxes but instead of showing all posts that include the ANY of the meta values selected I want to show posts that contain all of the selected values. Is this possible? Here is what I currently have using the "IN" operator which just checks if the post contains any single value in the array.
$the_query = new WP_Query(array( 'post_type' => 'listing', 'posts_per_page' => -1, 'post_status' => 'publish', 'category_name' => 'private_rental', 'orderby' => 'rand', 'meta_query' => array( 'key' => 'row_amenities', 'value' => $amenities, 'compare' => 'IN' ) ));