UBB.Dev
Posted By: UnixSpot Change titles of all users in a group - 06/26/2005 11:50 PM
How can I change the Title of every user in a group.

I have a group (GroupA) and every member in that group should have a custom title, the same title. Now I can do it by hand on each user but I have 400 users. Is there an SQL command or a script that can change them all for me?>

Thanks!
Posted By: scroungr Re: Change titles of all users in a group - 06/26/2005 11:52 PM
UPDATE w3t_Users SET U_Title = 'Widget' WHERE U_Groups LIKE '%-5-%' where 5 is the number of the group
Posted By: UnixSpot Re: Change titles of all users in a group - 06/27/2005 12:16 AM
Wonderful, that worked perfectly ... now what if I want to change a title ... lets say I have a bunch of users with the title "Board Member" and I want to change that title to "Board User", how could that be done.

Thank you!!!!!
Posted By: scroungr Re: Change titles of all users in a group - 06/27/2005 1:11 AM
UPDATE w3t_Users SET U_Title = 'Board User' WHERE U_Title = 'Board Member'
© UBB.Developers