id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
18158	Meta Query for posts with a meta key not set (IS NULL).	johnnyb	georgestephanis	"In the meta_query, we should be able to query for posts that don't have a certain meta key at all. I suggest a syntax something like this:

{{{
... 
meta_query => array(
        array(
            'key' => '_my_special_meta',
            'compare' => 'NOT EXISTS'
        )
    )
...
}}}

Alternately this could be handled invisibly along the lines of:
{{{
... 
meta_query => array(
        array(
            'key' => '_my_special_meta',
            'value' => 'a_value_this_might_have',
            'compare' => '!='
        )
    )
...
}}}

This could be done using a left join, and not some sort of special case like above.  Since it's a left join we may have to be careful that we don't end up with a bunch of junk rows in the query, however."	enhancement	closed	normal	3.5	Query	3.2.1	normal	fixed	has-patch needs-unit-tests commit	marko@… scott@… wycks micahwave chappellind@… dromsey@… coenjacobs@… aaroncampbell dancameron batmoo@… ehitter@… bananastalktome@… j.yzbek@… timersys xoodrew@…