Changeset 16170 for trunk/wp-includes/class-wp-object-query.php

Timestamp:

11/03/2010 07:31:11 PM (15 years ago)

Author:

ryan

Message:

Allow trailing wildcard user searches by appending *. see #15170

File:

• trunk/wp-includes/class-wp-object-query.php (modified) (1 diff)

trunk/wp-includes/class-wp-object-query.php

@@ -228 +228 @@
      * @param string $string
      * @param array $cols
+     * @param bool $wild Whether to allow trailing wildcard searches. Default is false.
      * @return string
      */
-    function get_search_sql( $string, $cols ) {
+    function get_search_sql( $string, $cols, $wild = false ) {
         $string = esc_sql( $string );
 
         $searches = array();
+        $wild_char = ( $wild ) ? '%' : '';
         foreach ( $cols as $col ) {
             if ( 'ID' == $col )
                 $searches[] = "$col = '$string'";
             else
-                $searches[] = "$col LIKE '$string%'";
+                $searches[] = "$col LIKE '$string$wild_char'";
         }