XF 1.5 Mass update users with existing email domain that we want to block

optrex

Well-known member
We're taking steps to block an email domain. We've stopped new users from registering, but have approximately 400 current users with this email address.
I'd like to mass move them to User State: email invalid (bounced)

Lets say the email domain is under xyz.com xyz.uk xyz.fr (etc)

What query would I need please?
 
Top