Had a client who wanted to get rid of all Hotmail addresses out of there phpList email lists. I ran a query and found over 700 emails with Hotmail in them.
Issue: Its not possible in PHPlist 2.10.17 to mass delete users based on a global variable – ie *@hotmail.com
1) Use PHPmyadmin to run a query to get the names
SELECT *FROM `phplist_user_user`
WHERE `email` LIKE ‘%hotmail.com%
2) I dumped them to CSV then cleaned it up so I was only left with the email names in one column.
3) In PHPlist I selected manage users and then mass unconfirm users. Paste it in and run it. Now all the Hotmail names I put in are unconfirmed.
4) Under manage users select reconcile users, scroll to the bottom where it says “To delete users who signed up and have not confirmed their subscription”, edit the date range and run. Done and done!
Hope this helps someone.