SQL Query : Mass move specific users based on usernames, not userid

[flyguye]

Hi,

I need to mass move specific users (a couple of hundred of them) based on their usernames, not based on their id, to be deleted at a later time.

Each user is unique, with differing post counts, join dates, etc.

I've tried to mess around with some SQL queries but no luck.

PHP Code:

UPDATE user 
SET usergroupid = X 
WHERE user = adam john mike etc 


I have the usernames on excel so if I could add them into the query either comma separated, or space separated, or line separated would be great! :up:

I've no knowledge on SQL, so I might be shootin' in the dark here!