I’ve a website which have 90k+ person with subscriber roles.I need delete person with solely subscriber function utilizing phpmyadmin . So I understand how to delete it However some customers have a number of roles for instance few customers have each editor and subscriber function . Now my question is deleting all of the person which subscriber roles together with customers which have a number of roles however I do not need that .So what ought to I replace in my question to delete customers which have solely subscriber function.
That is my present question
DELETE FROM wp_users INNER JOIN wp_usermeta ON wp_users.ID = wp_usermeta.user_id WHERE meta_key = 'wp_capabilities'AND meta_value LIKE '%subscriber% .
Any recommendation can be helpfull and thanks upfront and may anybody inform is this question additionally deleting fields in wp_usermeta proper?
