[flyguye]

Very kind of you sir! However the list isn't finalized yet, will PM you the list once it's finalized!

However, I don't understand what you mean by the usernames being escaped?

--------------- Added [DATE]1333624292[/DATE] at [TIME]1333624292[/TIME] ---------------

Managed to do it!

I used excel to add the 'apostrophes' and appropriate spaces at the end of each username, and pasted it in the following format:

UPDATE user 
SET usergroupid = X 
WHERE username IN(
'adam', 
'john', 
'mike'
)

Where X is the target usergroupid

That allowed me to paste the all the usernames at one go!

Thanks again! :up: SOLVED!