PDA

View Full Version : Mysql query urgent help needed!


jl255
03-03-2009, 01:01 AM
One of the mods have corrupted my DB and I need to find out which members have been affected. Appreciate some help on the mysql query syntax.

I need to find ALL members who have the custom profile field, gender = Girl BUT NOT ASSIGNED to the secondary usergroup=Females.

Can someone help me with the query syntax to find this list of members? Tks! :(

Dismounted
03-03-2009, 04:42 AM
Can members be in more than one secondary usergroup?