Title: Querying database for users
Last modified: February 13, 2017

---

# Querying database for users

 *  [olliew](https://wordpress.org/support/users/olliew/)
 * (@olliew)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/querying-database-for-users/)
 * I am using the following code
    `$authors = $wpdb->get_results("SELECT ID, user_nicename
   from $wpdb->users ORDER BY display_name");` It is selecting all users including
   subscribers and customers from WooCommerce. How would I select only those people
   with a role of author, editor or contributor?
 * I had a look through the database but couldn’t figure it out. descriptionhttps://
   codex.wordpress.org/Database_Description#Table:_wp_users

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Luis Sacristán](https://wordpress.org/support/users/displaynone/)
 * (@displaynone)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/querying-database-for-users/#post-8798557)
 * Hi, perhaps you should use get_users
 * [https://codex.wordpress.org/Function_Reference/get_users](https://codex.wordpress.org/Function_Reference/get_users)
 * Using role__in parameter
 * Hope it helps you
 *  Thread Starter [olliew](https://wordpress.org/support/users/olliew/)
 * (@olliew)
 * [9 years, 3 months ago](https://wordpress.org/support/topic/querying-database-for-users/#post-8802976)
 * Thanks, that works!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Querying database for users’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * In: [Developing with WordPress](https://wordpress.org/support/forum/wp-advanced/)
 * 2 replies
 * 2 participants
 * Last reply from: [olliew](https://wordpress.org/support/users/olliew/)
 * Last activity: [9 years, 3 months ago](https://wordpress.org/support/topic/querying-database-for-users/#post-8802976)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics