Title: wp_users – MySql   WordPress
Last modified: August 20, 2016

---

# wp_users – MySql WordPress

 *  [PH web dev](https://wordpress.org/support/users/wer0ckz/)
 * (@wer0ckz)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/wp_users-mysql-wordpress/)
 * Hi guys. I need a little help please. How can I query in phpmyadmin to display
   users with administrator roles only?
 * Example: SELECT user_login FROM wp_users Where role=”administrator”
 * That query doesn’t work. Can you help me guys how to correct the sql query?
 * Thanks in advanced.

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

 *  [s_ha_dum](https://wordpress.org/support/users/apljdi/)
 * (@apljdi)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/wp_users-mysql-wordpress/#post-2895318)
 * Assuming I haven’t made a typo somewhere …
 *     ```
       SELECT user_login FROM wp_users LEFT JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id WHERE wp_usermeta.meta_key = 'wp_capabilities' AND wp_usermeta.meta_value LIKE '%administrator%'
       ```
   
 *  Thread Starter [PH web dev](https://wordpress.org/support/users/wer0ckz/)
 * (@wer0ckz)
 * [13 years, 10 months ago](https://wordpress.org/support/topic/wp_users-mysql-wordpress/#post-2895432)
 * thank you so much! it worked!

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

The topic ‘wp_users – MySql WordPress’ is closed to new replies.

 * 2 replies
 * 2 participants
 * Last reply from: [PH web dev](https://wordpress.org/support/users/wer0ckz/)
 * Last activity: [13 years, 10 months ago](https://wordpress.org/support/topic/wp_users-mysql-wordpress/#post-2895432)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics