Pages Menu
TwitterRss

Jon Bishop

WordPress, Social Media and Web Development

Categories Menu

Posted by on Jan 2, 2012 in | 0 comments

Search User Meta On Users Page

function my_user_query($wp_query){
global $wpdb, $pagenow;
if($pagenow == ‘users.php’){
$qv = &$wp_query->query_vars;
if(trim($qv['search']) != “”){
$search = trim($qv['search'], ‘*’);

$wp_query->query_from = “FROM $wpdb->users”;
$wp_query->query_from .= ” LEFT JOIN $wpdb->usermeta”;
$wp_query->query_from .= ” ON $wpdb->usermeta.user_id = $wpdb->users.ID”;

$wp_query->query_where = “WHERE 1=1 AND ($wpdb->users.user_login LIKE ‘%” . $search. “%’ OR $wpdb->users.user_nicename LIKE ‘%” . $search . “%’)”;
$wp_query->query_where .= ” OR $wpdb->usermeta.meta_value LIKE ‘%” . $search . “%’”;
}
}
}
add_action(‘pre_user_query’, ‘my_user_query’);