Bulk remove users
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?
DELETE FROM pp_users WHERE posts=0 AND views=0;
Yes of course, so simple. Thanks.
Yep simple mysql query based off what you wanted.
|All times are GMT -5. The time now is 03:38 AM.|
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0