Hi, I have this query to select my wordpress subscribers, but, now I need to delete them. Can someone help me change this to work?
I would need to delete their rows from the wp_users table and all associated data from the wp_usermeta table.
SELECT user_id, user_id
AS ID, user_login, display_name, user_email, meta_value
FROM wp_users, wp_usermeta
WHERE wp_users.ID = wp_usermeta.user_id
AND meta_value LIKE '%subscriber%'
ORDER BY wp_usermeta.user_id