Changeset 21185 for trunk/wp-includes/meta.php

Timestamp:

06/29/2012 07:59:29 PM (12 years ago)

Author:

nacin

Message:

Add NOT EXISTS to meta queries, allowing you to query for the non-existence of a meta key.

You could already use EXISTS by omitting a value to check.

props georgestephanis, scribu
fixes #18158

File:

• trunk/wp-includes/meta.php (modified) (2 diffs)

trunk/wp-includes/meta.php

@@ -721 +721 @@
                 $meta_type = 'CHAR';
 
+            $meta_value = isset( $q['value'] ) ? $q['value'] : null;
+
+            if ( isset( $q['compare'] ) )
+                $meta_compare = strtoupper( $q['compare'] );
+            else
+                $meta_compare = is_array( $meta_value ) ? 'IN' : '=';
+
+            if ( ! in_array( $meta_compare, array(
+                '=', '!=', '>', '>=', '<', '<=',
+                'LIKE', 'NOT LIKE',
+                'IN', 'NOT IN',
+                'BETWEEN', 'NOT BETWEEN',
+                'NOT EXISTS'
+            ) ) )
+                $meta_compare = '=';
+
             $i = count( $join );
             $alias = $i ? 'mt' . $i : $meta_table;
 
-            // Set JOIN
+            if ( 'NOT EXISTS' == $meta_compare ) {
+                $join[$i]  = "LEFT JOIN $meta_table";
+                $join[$i] .= $i ? " AS $alias" : '';
+                $join[$i] .= " ON ($primary_table.$primary_id_column = $alias.$meta_id_column AND $alias.meta_key = '$meta_key')";
+
+                $where[$k] = ' ' . $alias . '.' . $meta_id_column . ' IS NULL';
+
+                continue;
+            }
+
             $join[$i]  = "INNER JOIN $meta_table";
             $join[$i] .= $i ? " AS $alias" : '';
@@ -733 +758 @@
                 $where[$k] = $wpdb->prepare( "$alias.meta_key = %s", $meta_key );
 
-            if ( !isset( $q['value'] ) ) {
+            if ( is_null( $meta_value ) ) {
                 if ( empty( $where[$k] ) )
                     unset( $join[$i] );
                 continue;
             }
-
-            $meta_value = $q['value'];
-
-            $meta_compare = is_array( $meta_value ) ? 'IN' : '=';
-            if ( isset( $q['compare'] ) )
-                $meta_compare = strtoupper( $q['compare'] );
-
-            if ( ! in_array( $meta_compare, array( '=', '!=', '>', '>=', '<', '<=', 'LIKE', 'NOT LIKE', 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN' ) ) )
-                $meta_compare = '=';
 
             if ( in_array( $meta_compare, array( 'IN', 'NOT IN', 'BETWEEN', 'NOT BETWEEN' ) ) ) {