Delete Spam users from a Joomla Database with phpMyAdmin
Sometimes a Site with registration gets hammered by spam bot registrations.
Removing hundreds or thousands of registrations is very time consuming manually.
This command in sql will delete users with duplicate names
Deletes users who have never activated
DELETE from 'jos_users' WHERE lastvisitDate=’0000-00-00 00:00:00′