[wp-trac] [WordPress Trac] #18158: Meta Query for posts with a meta key not set (IS NULL).

WordPress Trac wp-trac at lists.automattic.com
Sun Jun 17 03:54:37 UTC 2012


#18158: Meta Query for posts with a meta key not set (IS NULL).
-----------------------------------------------+---------------------------
 Reporter:  johnnyb                            |       Owner:
     Type:  enhancement                        |  georgestephanis
 Priority:  normal                             |      Status:  accepted
Component:  Query                              |   Milestone:  3.5
 Severity:  normal                             |     Version:  3.2.1
 Keywords:  has-patch needs-unit-tests commit  |  Resolution:
-----------------------------------------------+---------------------------
Changes (by scribu):

 * keywords:  has-patch needs-unit-tests commit early => has-patch needs-
     unit-tests commit
 * milestone:  Future Release => 3.5


Comment:

 > wouldn't a multi-parameter join most often be more efficient than a
 single-param join and a where clause?

 I don't know. Do an EXPLAIN and share what you find out.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/18158#comment:40>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list