Hi, like most forums we get a number of spam users signing up. They often share the same e-mail domain such as mail.ru. I have many of these users and I want to remove them from the database. Is there no standard way of removing many users based on their e-mail addresses?
Oh right, that's quite surprising. The mass prune options do seem quite limited, for example you way wish to mass remove people with certain words in their profiles, or in my case, everyone on the same e-mail domain.
Perhaps someone could advise me on a MySQL statement that would remove all users with the same e-mail domain in their records? That'd achieve the same thing.
02-14-2007, 09:30 AM
Being stupid? Mass prune by e-mail address?
Linear Mode
