WordPress.org

1. Melbourne Cup Odds
   Member
   Posted 2 years ago #

   Hi,

   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
   Member
   Posted 2 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 Odds
   Member
   Posted 2 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.