[RichieBoy67]

Originally Posted by ForceHSS

PHP Code:

UPDATE `user` SET `usergroupid`= x WHERE `email` LIKE '%.xmail.com' 


this will change usergroupid to what you set x to

Yeah, that is only the first part of the query. Not only do I want to change the usergroup of those with certain email addresses but i want to remove those addresses from the user accounts. This is the part of the query I am having trouble with.

Thanks for the reply my friend!

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

Originally Posted by Lynne

Just a note to say you should always test queries on a test site first and before doing so on the live site make sure to make a database backup.

Thanks Lynn, I will make a back up before hand but I am not going to run anything until I am sure it is what I want.