Trying to run a query to find Wordpress users with a specified capability.
I tried the following, without success...
SELECT u.ID, u.user_login
FROM wp_users u, wp_usermeta m
WHERE u.ID = m.user_id
AND m.meta_key LIKE 'wp_capabilities'
AND m.meta_value LIKE '%install_plugins%'
Would like some help formatting the query correctly to get the desired result.
Thanks.