Changeset 28720

Timestamp:

06/10/2014 02:19:30 AM (10 years ago)

Author:

wonderboymusic

Message:

In WP_Comment_Query::get_search_sql(), don't double-like-escape.

Props miqrogroove.
See #10041.

File:

• trunk/src/wp-includes/comment.php (modified) (1 diff)

trunk/src/wp-includes/comment.php

@@ -484 +484 @@
         global $wpdb;
 
+        $like = '%' . $wpdb->esc_like( $string ) . '%';
+
         $searches = array();
-        foreach ( $cols as $col )
-            $searches[] = $wpdb->prepare( "$col LIKE %s", $wpdb->esc_like( $string ) );
+        foreach ( $cols as $col ) {
+            $searches[] = $wpdb->prepare( "$col LIKE %s", $like );
+        }
 
         return ' AND (' . implode(' OR ', $searches) . ')';