![]() |
MySql Query help
Is there a way to change 30 or 40 members to a different usergroup (all at once) using MySql? I tried to figure this out on my own, but it didn't figure out right :)
Thanks, Jack |
Try something like:
[sql] UPDATE user SET usergroupid='1' WHERE userid IN (2) [/sql] where 1 = usergroupid and 2 are the userid's seperated by , (like: 1,2,3) |
Thank you Lesane, but I think I messed this up too. I tried this:
Code:
UPDATE user SET usergroupid='8' WHERE userid IN (test1,test2,test3,test4) (test1,test2,test3,and test4 are new members I added before doing the query) Thanks again, Jack |
Nevermind......I'm stupid.
User ID, not username. It worked like a champ. You've saved me hours of individual changes, Thanks again :) Jack |
hehe np, glad i could help.
|
All times are GMT. The time now is 01:36 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|