Filter and Order by Multiple Custom Meta Values

Question

For multiple meta value you have to use “IN”

$args = array(
    'posts_per_page' => -1,
    'post_type' => 'shows',
    'orderby' => 'meta_value_num',
    'meta_key' => 'start_date',
    'order' => 'ASC',
    'meta_query' => array(
            array(
            'key' => 'show_location',
            'value' => array('second','third'),
            'compare' => 'IN'
            )
    )
);                  
// get results
$the_query = new WP_Query( $args );

The IN comparison checks for the post to be available with the values that are present in the ‘meta_value’ array.