RESOLVED: Need help assigning bulk users to group

[MAlbelo]

I've been tasked with assigning all members registered between 2 dates to a usergroup. I'm using VB 4.2.2.

I have access to PHPMyAdmin and can run queries on the DB Directly. Unfortunately U don't know enough of SQL to put together the right statements.

This is what I want to do essentially.

For JoinDate between 1/1/2014 and 7/31/2014 add Group ID 11 to MemberGroupIDS

I need to add the Group ID(Secondary UserGroup) to the MemberGroupIDS.

If I didn't have 6000 accounts to deal with, I'd just do it manually. I've look a the Prune/Move in Admin, but that doesn't help as I just need to add them as a secondary group.

Any help is greatly appreciated.

Thank you.

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

I was able to figure it out on my own using this query at my base.

UPDATE users
SET membergroupids = '11'
WHERE joindate < 1406851200
AND joindate > 1388534400
AND membergroupids = ''

This assigned all users that joined between 1/1/2014 and 7/31/2014 that had no membergroupids to group 11.