How to Delete Stupidly Long Usernames?
-
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.
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘How to Delete Stupidly Long Usernames?’ is closed to new replies.