I would like to get a list of user_nicenames and the ID. But not all the usernames which is what i'm getting now. I understand I should use the % before and after the $name only nothing seems to be working. This is the only way to get some output I found till now;
global $wpdb; //get access to the WordPress database object variable //get names of all users $name = $wpdb->esc_like(stripslashes($_POST['name'])).'%'; //escape for use in LIKE statement $sql = "SELECT user_nicename, ID FROM $wpdb->users WHERE user_nicename LIKE %s "; $sql = $wpdb->prepare($sql, $name); $results = $wpdb->get_results($sql);
How do I limit the output to only user_nicenames starting with, so
$_POST['name'] .'%' in normal php code.