Query multiple meta key values?

by

I feel like there’s an AND/OR confusion going on here.

The queries in the OP will only return posts which have both key1 = ‘value1’ AND key2 = ‘value2’. Most WP plugins (that I know of, anyway) do not store multiple values in postmeta, for the same post, using the same key.

If what you want is really an OR (you want to get the posts where key1 = ‘value1’, as well as the posts where key1 = ‘value2’), then see @WhiskerSandwich’s answer, using ‘IN’ and an array of values for the value parameter.

Alternatively, you can provide a relation parameter to `meta_query’:

$args = array(
    'meta_query' => array(
        'relation' => 'OR',
        array(
            'key' => 'key1',
            'value' => 'value1',
            'compare' => '='
        ),

        array(
            'key' => 'key1',
            'value' => 'value2',
            'compare' => '='
        )
    )
);

Note that using OR as the relation for multiple meta queries using the same key is the functional equivalent of using IN and an array of values for a single one.

Leave a Comment