|Posted: Sunday Jul 21st, 2013 at 11:26 pm #53792|
I need to bulk downgrade many users to subscriber level.
The WordPress installation has 15,597 users.
I need to downgrade/demote to subscriber level/role:
Obviously I don’t want to do this manually when there is phpmyadmin and SQL waiting for me :)
The closest SQL I was able to get was:
AFTER backing up the database, when I ran that in phpmyadmin it said 52 rows affected. However all of the users in the database were demoted to subscriber.
Can you good SQL guru people share SQL that can do what I need to do?
- s2Member® Products