Quote:
Originally Posted by
RudiC
Would it make sense to check usernames for patterns (like the recent "125" suffix) before updating / deleting?
If you want to write many pattern matching SQL queries like that, "please go for it" ...
Most the "recent spammers" have already been purged based on other criteria.
Feel free to suggest any MySQL query you like.
Normally these queries should be "in pairs". One MySQL "select" query to test; and then a delete or update query to "do the deed".
I cannot emphasis this enough, and keep (unsuccessfully) encouraging the technical team here at UNIX.COM (who are all very capable and highly technical) to communicate ideas in the actual code (MySQL query for DB suggestions, CSS/HTML/jQuery/Javascript for web site suggestions, etc.)
Thanks