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!