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’);

