do_action_ref_array( ‘pre_user_query’, WP_User_Query $query )

User Contributed Notes

1. Skip to note 2 content

   tikot 8 years ago

   You must log in to vote on the helpfulness of this noteVote results for this note: 2You must log in to vote on the helpfulness of this note

   Find user by usermeta add change the meta key or add more meta keys OR meta_key='key_name' between () on WHERE line

   <?php
   
   add_action( 'pre_user_query', function( $uqi ) {
       global $wpdb;
   
       $search = '';
       if ( isset( $uqi->query_vars['search'] ) )
           $search = trim( $uqi->query_vars['search'] );
   
       if ( $search ) {
           $search = trim($search, '*');
           $the_search = '%'.$search.'%';
   
           $search_meta = $wpdb->prepare("
           ID IN ( SELECT user_id FROM {$wpdb->usermeta}
           WHERE ( ( meta_key='first_name' OR meta_key='last_name' )
               AND {$wpdb->usermeta}.meta_value LIKE '%s' )
           )", $the_search);
   
           $uqi->query_where = str_replace(
               'WHERE 1=1 AND (',
               "WHERE 1=1 AND (" . $search_meta . " OR ",
               $uqi->query_where );
       }
   });