I need an SQL query to move users that have a profile option selected to a new user group in vBulletin .
I have a modification on my vBulletin 4.1 site that allows a user to select the country they are from. This shows up in their profile as a custom user profile field. I would like a query that would allow me to enter in the selected option of that profile field and move all users with that option to a new user group.
The mod installed can be viewed here:
[url removed, login to view]