Hi I'm trying to select users with a particular role only, using the following sql statement...
SELECT DISTINCT ID, u.user_login, u.user_nicename, u.user_email FROM wp_users u, wp_usermeta m WHERE m.meta_key = 'wp_capabilities' AND m.meta_value LIKE '%supplier%' ORDER BY u.user_registered
However, it reurns the whole table. What am I doing wrong?
PS this needs to be a SQL select as I'm doing this in myphpadmin to export the data to csv.
Thanks in advance!