PDA

View Full Version : Help forming an SQL Query


kronnos
02-18-2010, 01:44 PM
I had a few hundred subscribed members in primary usergroup but now want to change them all to secondary usergroup.

Basically, Im trying to form an sql query that would

Select all users with primary usergroup "A"
Then change that "A" to a "B" in the primary usergroup
Then add "A" to that users secondary group(some users have more then one secondary membership group)
And set the display group of all these users to "A"


A huge thanks in advance!