WordPress.org

Make WordPress Core

Changeset 13503


Ignore:
Timestamp:
02/28/10 13:15:54 (5 years ago)
Author:
dd32
Message:

remove LOWER() in Order by clause for Post Meta. Allows MySQL to use the indexes properly. Props Denis-de-Bernardy. Fixes #11741

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/wp-admin/includes/template.php

    r13489 r13503  
    24282428        GROUP BY meta_key 
    24292429        HAVING meta_key NOT LIKE '\_%' 
    2430         ORDER BY LOWER(meta_key) 
     2430        ORDER BY meta_key 
    24312431        LIMIT $limit" ); 
    24322432    if ( $keys ) 
     
    32893289                <label class="screen-reader-text" for="find-posts-input"><?php _e( 'Search' ); ?></label> 
    32903290                <input type="text" id="find-posts-input" name="ps" value="" /> 
    3291                 <input type="button" onclick="findPosts.send();" value="<?php esc_attr_e( 'Search' ); ?>" class="button" /><br /> 
     3291                <input type="button" onClick="findPosts.send();" value="<?php esc_attr_e( 'Search' ); ?>" class="button" /><br /> 
    32923292 
    32933293                <input type="radio" name="find-posts-what" id="find-posts-posts" checked="checked" value="posts" /> 
     
    32993299        </div> 
    33003300        <div class="find-box-buttons"> 
    3301             <input type="button" class="button alignleft" onclick="findPosts.close();" value="<?php esc_attr_e('Close'); ?>" /> 
     3301            <input type="button" class="button alignleft" onClick="findPosts.close();" value="<?php esc_attr_e('Close'); ?>" /> 
    33023302            <input id="find-posts-submit" type="submit" class="button-primary alignright" value="<?php esc_attr_e('Select'); ?>" /> 
    33033303        </div> 
Note: See TracChangeset for help on using the changeset viewer.