Mass Moving User Groups via email domain

[PDT816]

Over the lifetime of my board, I've amassed a large number of users from the same organization. Now I want to be able to move them from my "registered" user group to another group via the domain included in their email address.

I'm assuming it's going to look something like this:

UPDATE user SET usergroupid=newgroup WHERE email= **@abc.com

Couple of questions:

Not sure what to use as the wildcard for everthing that comes before the email's domain name.
I'm assuming that I can do this in phpmyadmin?

Thanks in advance.

[Odysseus]

1. Use the percent-symbol instead of the star: "UPDATE user SET usergroupid=xyz WHERE email LIKE ´%@abc.com´"

2. Yes, this is possible. Use the "SQL" command box to do so.

Please be sure to male a backup copy of you "user" table BEFORE applying any changes to it! Double-check that this backup is functional and correct!