Changeset 36647 for trunk/src/wp-includes/query.php

Timestamp:

02/23/2016 08:13:22 PM (9 years ago)

Author:

boonebgorges

Message:

Query: Search should match post_excerpt in addition to title and content.

When ordering search results, exact matches in the post excerpt are weighted
above those in post content, but below those in the post title.

Props swissspidy, sebastian.pisula.
FIxes #35762.

File:

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

trunk/src/wp-includes/query.php

@@ -2157 +2157 @@
 
             $like = $n . $wpdb->esc_like( $term ) . $n;
-            $search .= $wpdb->prepare( "{$searchand}(($wpdb->posts.post_title $like_op %s) $andor_op ($wpdb->posts.post_content $like_op %s))", $like, $like );
+            $search .= $wpdb->prepare( "{$searchand}(($wpdb->posts.post_title $like_op %s) $andor_op ($wpdb->posts.post_excerpt $like_op %s) $andor_op ($wpdb->posts.post_content $like_op %s))", $like, $like, $like );
             $searchand = ' AND ';
         }
@@ -2281 +2281 @@
             }
 
-            // sentence match in 'post_content'
+            // Sentence match in 'post_content' and 'post_excerpt'.
             if ( $like ) {
-                $search_orderby .= $wpdb->prepare( "WHEN $wpdb->posts.post_content LIKE %s THEN 4 ", $like );
+                $search_orderby .= $wpdb->prepare( "WHEN $wpdb->posts.post_excerpt LIKE %s THEN 4 ", $like );
+                $search_orderby .= $wpdb->prepare( "WHEN $wpdb->posts.post_content LIKE %s THEN 5 ", $like );
             }
 
             if ( $search_orderby ) {
-                $search_orderby = '(CASE ' . $search_orderby . 'ELSE 5 END)';
+                $search_orderby = '(CASE ' . $search_orderby . 'ELSE 6 END)';
             }
         } else {