How to Delete Stupidly Long Usernames? (3 posts)

  1. Melbourne Cup Sweep
    Posted 5 years ago #


    I have an article directory using the wordpress platform, since it is set up so anybody can register, I obviously have some trouble with spammers. They don't cause huge problems but some register their usernames as whole paragraphs. I have 40,000 users that I need to sort through.

    I am desperate for a mysql query I can use to find user names that are excessively long. A query that searches wp_users and finds user_nicename that are over X amount of characters long.

    Is this possible? If so, could someone do me a huge favor and give me an example of a mysql query to perform to achieve this?

    Thanks a million.

  2. Inspired2Write
    Posted 5 years ago #

    Are you using anything like Bad Behavior? It won't do what you're asking, but stop allot of them from potentially harmful activity.

  3. Melbourne Cup Sweep
    Posted 5 years ago #

    No im not, but I will implement it thanks.

    Does anybody else know how to fix my issue?

Topic Closed

This topic has been closed to new replies.

About this Topic