Remove ICQ/MSN/YAHOO/BIO etc. of around 1600 users via Phpmyadmin.

[SaN-DeeP]

Yes it worked fine.., gives all users not are not in Group ID - 117

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

and this

SELECT username FROM vb3_user WHERE FIND_IN_SET(117, membergroupids) = 1

gives all user who are in group 117 properly.

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

should i try
UPDATE vb3_user SET password=MD5(CONCAT(MD5('XXYYZZ1122'),salt)) WHERE FIND_IN_SET(117, membergroupids) != 1
OR
UPDATE vb3_user SET password=MD5(CONCAT(MD5('XXYYZZ1122'),salt)) WHERE FIND_IN_SET(117, membergroupids) != 0

dont want to risk.