Changeset 15723 for trunk/wp-includes/classes.php

Timestamp:

10/04/2010 09:05:31 PM (16 years ago)

Author:

scribu

Message:

Move _wp_search_sql() into WP_Object_Query. Introduce WP_Comment_Search. See #15032

File:

• trunk/wp-includes/classes.php (modified) (3 diffs)

trunk/wp-includes/classes.php

@@ -547 +547 @@
      * Populates the $meta_query property
      *
-     * @access private
+     * @access protected
      * @since 3.1.0
      *
@@ -571 +571 @@
      * Used internally to generate an SQL string for searching across multiple meta key = value pairs
      *
-     * @access private
+     * @access protected
      * @since 3.1.0
      *
@@ -621 +621 @@
 
         return array( $join, $where );
+    }
+
+    /*
+     * Used internally to generate an SQL string for searching across multiple columns
+     *
+     * @access protected
+     * @since 3.1.0
+     *
+     * @param string $string
+     * @param array $cols
+     * @return string
+     */
+    function get_search_sql( $string, $cols ) {
+        $string = esc_sql( $string );
+
+        $searches = array();
+        foreach ( $cols as $col )
+            $searches[] = "$col LIKE '%$string%'";
+
+        return ' AND (' . implode(' OR ', $searches) . ')';
     }
 }