How to make a mass request for changes in the user base?

Question

SQL

Hello.
Please tell me, on the XenForo forum, you need to change the group for the address list.
Admin means does not work, there is a search for certain criteria, maybe it can be done through sql?

There is a list in which, through the email address string
There is a mysql database with a user table in which there are these email addresses

There are several groups, you need to massively set the required group ID for this email list
The user structure is like this

How to make a query correctly?
Select user from email set user_group_id group

Answer 1

Make LOAD DATAaddresses and then UPDATEwith IN.