These SQL statements help get rid of unwanted members that may have spammed your ExpressionEngine 2.x site. Be sure to include the correct member IDs that you want to keep!

ee2x-delete-members.sql

DELETE FROM exp_member_homepage
WHERE member_id not in ( 1, 2, 3 )

DELETE FROM exp_member_data
WHERE member_id not in ( 1, 2, 3 )

# 'Members' member group
DELETE FROM exp_members
WHERE group_id = 5
AND member_id not in ( 1, 2, 3 )

# 'Pending' member group
DELETE FROM exp_members
WHERE group_id = 4
AND member_id not in ( 1, 2, 3 )

DELETE FROM `exp_comments` WHERE `author_id` = 0