View Full Version : Bulk remove users
January 21st, 2012, 03:16 PM
I have a large number of old user account, mostly unregistered, with 0 views and 0 posts. The usernames and email addresses are clearly not genuine Is there a way with some SQL that I can remove all of them that have 0 views and 0 posts?
January 21st, 2012, 08:22 PM
DELETE FROM pp_users WHERE posts=0 AND views=0;
January 22nd, 2012, 04:02 AM
Yes of course, so simple. Thanks.
January 22nd, 2012, 09:51 AM
Yep simple mysql query based off what you wanted.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.