[Forum] Execute SQL Query- How do I change Custom User Profile Field options, for multiple Usergroups/Users?

[akz645]

vB 4.2.3

As the title suggest, what would I need to write in the Execute SQL Query option (http://i.imgur.com/WZP9MO6.png), for users/usergroups to have their Custom User Profile Field options forcefully be changed?
They can still change back from their userCP later.

This is the code that forces/automatically changes Usergroups X Show Reputation to Hide Reputation in their userCP (http://i.imgur.com/ALEUmXT.png):

UPDATE user SET options=options - 1024 WHERE options & 1024 AND usergroupid IN([COLOR=red]X[/COLOR],[COLOR=red]X[/COLOR],[COLOR=red]X[/COLOR]);

Example:
I have a custom user profile field named: Gender [Field5]
Options:
Male
Female
Hide
These are the rest of my data for the user profile field: http://i.imgur.com/kDACrUL.png -> Single-Selection Menu.

How do I change certain users/usergroups just from Male to Hide?
Also, if I wanted to change certain users/usergroups from Male & Female to Hide, how would I do that?

Does the Profile Field Type (http://i.imgur.com/1H7oCUJ.png) matter when executing a query like this?

[glennrocksvb]

Try this (untested):

UPDATE userfield SET field5='Hide' where userid in (SELECT userid FROM user WHERE usergroupid IN (X, X, X))

It is recommended to backup the database before performing this query.

[akz645]

Try this (untested):

UPDATE userfield SET field5='Hide' where userid in (SELECT userid FROM user WHERE usergroupid IN (X, X, X))

It is recommended to backup the database before performing this query.

Cheers that worked

However, is there any way I can get it even more specific?

So only users who have selected Male gets changed to Hide? Hence all users who have selected Female from the userCP are left unchanged.
---
If I add in the option Bisexual.
How would I just get only Male & Female to Hide? Hence all users who have selected Bisexual from the userCP are left unchanged.
(this is just an example, I have other user profile manger which I may need this for)

[glennrocksvb]

So only users who have selected Male gets changed to Hide? Hence all users who have selected Female from the userCP are left unchanged.

UPDATE userfield SET field5='Hide' where field5='Male' AND userid in (SELECT userid FROM user WHERE usergroupid IN (X, X, X))

---
If I add in the option Bisexual.
How would I just get only Male & Female to Hide? Hence all users who have selected Bisexual from the userCP are left unchanged.
(this is just an example, I have other user profile manger which I may need this for)

UPDATE userfield SET field5='Hide' where (field5='Male' OR field5='Female') AND userid in (SELECT userid FROM user WHERE usergroupid IN (X, X, X))

[akz645]

UPDATE userfield SET field5='Hide' where field5='Male' AND userid in (SELECT userid FROM user WHERE usergroupid IN (X, X, X))

UPDATE userfield SET field5='Hide' where (field5='Male' OR field5='Female') AND userid in (SELECT userid FROM user WHERE usergroupid IN (X, X, X))

I just tried both conditions. It works as intended.

Thank you so much

I posted your solutions over here:

http://www.vbulletin.org/forum/showthread.php?p=2555897#post2555897