SQL User Query by Multiple Roles using PHP

Question

I can successfully get all my WordPress users using the following code:

global $wpdb; $sql = 'SELECT * FROM ' . $wpdb->users; $users = $wpdb->get_results( $sql, 'ARRAY_A' );

However, I need to filter the users with multiple roles (only get "role1" and "role2"). I have tried various methods including the following which does not work:

global $wpdb; $sql = ' SELECT ID, display_name FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) WHERE 1=1 AND ( ( ( ( mt1.meta_key = 'wp_capabilities' AND mt1.meta_value LIKE '%role1%' ) ) AND ( ( ( mt1.meta_key = 'wp_capabilities' AND mt1.meta_value LIKE '%role2%' ) ) ) ) ) ORDER BY user_login ASC '; $users = $wpdb->get_results( $sql, 'ARRAY_A' );

you can do that with the function get_users.

Kaperto
– Kaperto

2019-11-27 22:31:04 +00:00
Commented Nov 27, 2019 at 22:31 — Kaperto
– Kaperto, Commented Nov 27, 2019 at 22:31
Thank you. That worked...

Michael
– Michael

2019-11-27 23:03:08 +00:00
Commented Nov 27, 2019 at 23:03 — Michael
– Michael, Commented Nov 27, 2019 at 23:03
@Kaperto can you post your answer as an answer?

Tom J Nowell
– Tom J Nowell ♦

2019-11-27 23:10:30 +00:00
Commented Nov 27, 2019 at 23:10 — Tom J Nowell
– Tom J Nowell ♦, Commented Nov 27, 2019 at 23:10

Michael · Accepted Answer · 2019-12-02 22:27:12Z

Taking @Kaperto's advice, I did the following which works:

$user_query = new WP_User_Query( array( 'role__in' => ['role1','role2''], 'orderby' => 'meta_value_num', 'order' => 'ASC', ) ); $users = $user_query->get_results();

Stack Exchange Network

SQL User Query by Multiple Roles using PHP

1 Answer 1

Hot Network Questions

SQL User Query by Multiple Roles using PHP

1 Answer 1

Related

Hot Network Questions