Skip to content

Instantly share code, notes, and snippets.

@richardsweeney
Last active August 29, 2015 14:27
Show Gist options
  • Select an option

  • Save richardsweeney/73a1b684dbd3dedeac31 to your computer and use it in GitHub Desktop.

Select an option

Save richardsweeney/73a1b684dbd3dedeac31 to your computer and use it in GitHub Desktop.
<?php
if ( '' != $query->query_vars['search'] ) {
$meta_term = str_replace( '*', '', $query->query_vars['search'] );
$query->query_fields = 'DISTINCT SQL_CALC_FOUND_ROWS wp_users.ID';
$query->query_from = "FROM $wpdb->users LEFT JOIN $wpdb->usermeta ON $wpdb->usermeta.user_id = $wpdb->users.ID";
$query->query_where .= " OR display_name LIKE '%$meta_term%' OR ($wpdb->usermeta.meta_key = 'first_name' AND $wpdb->usermeta.meta_value = '{$meta_term}') OR ($wpdb->usermeta.meta_key = 'last_name' AND $wpdb->usermeta.meta_value = '{$meta_term}')";
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment