• Thinking that forcing people to register for my site would help stop the spammers, I made this a requirement. Now I have about 17,000 spam registrants. Since I still moderate all comments, the only consequence of this is the slew of fake users. Unfortunately, this seems to have slowed down the site and I want to delete them. Since most of these spammers use email sites such as outlook.com to generate a fake email address, it is easy enough to spot the fakes. But removing them is a tedious job since WP only shows 20 registrants per page at a time.

    I am hoping there is a way to get into the database through another door that would allow me to search for and delete the buggers en masse. Anyone know of a way? I have checked the forums and most posts on this issue are old.

    Thanks.

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter Bad_Egg

    (@bad_egg)

    Oh, and I’m using WP 3.6 and Pagelines.

    you can mass delete with mysql query in users table.

    Thread Starter Bad_Egg

    (@bad_egg)

    Hi:

    I have learned how to get into the database but do not know the proper syntax for the query. The default query is this:

    SELECT * FROM wp_users WHERE 1

    In the columns I have “user_email” as an option. I want to delete all users with “@outlook.com” in their user email address. What would the query read as?

    Thanks,
    Michelle

    Fist take Backup then you can run this query DELETE FROM wp_users WHERE user_email LIKE '%@outlook.com%' if you are not so familiar how to restore from backup then i would suggest to delete them manually to stay on safe side

    Thread Starter Bad_Egg

    (@bad_egg)

    Thanks. (Sorry for the late reply; was away for awhile.)

    Michelle

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Mass delete of registered scam users’ is closed to new replies.