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

[SaN-DeeP]

Hello once again.
I was able to sucessfully use following command for 1 site:

UPDATE user set password=MD5(CONCAT(MD5('XXYYZZ1122'),salt))

Which successfully worked for all users.. Big thanks..

************************************************** *************

But for another complex site.. which has few different user groups..
(Many Paid members here offline/online payment method, differentiated into multiple groups by mode of payment/amount etc.)

Example:
UserOne belongs to GROUP NAME Members ID = 2
UserOne is also under another GROUP NAME Paid Donors ID = 117 - This is like an Additional Group member belongs too.

Trying to run the queries you guided me with, these are results.

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

Gives this:
Results: 0 (2.5048s), Page 1 of 0

UPDATE vb3_user SET password=MD5(CONCAT(MD5('XXYYZZ1122'),salt)) WHERE FIND_IN_SET(117, membergroupids) != NULL

Gives this:
Confirm Query Execution
This query may modify data in your database. If this change is done in error, it is possible that you will not be able to recover from this change. Are you sure you wish to continue?

Affected Rows: 0 (3.3929s)

There are many users in Group ID - 117

Seems I am missing something ?