[SaN-DeeP]

Dear kh99,
Thanks again for keeping with me and your quick answers.

The database only has users NO CONTENT/NO POSTS/NO THREADS..
I dont want to delete all the users, as those were registered few years ago.. and its from a VERY UNIQUE NICHE..
But we have around 500+ banned spammers as well..
We promoted that site few years ago, then closed because of busy schedule. time to re-launch again soon.

I want to run a query.. which can change passwords for all users who belong to a specific usergroup (primary or secondary) to fasten my process.
I will manage changing the usernames manually via PHPMYADMIN which works perfect..

THANKS FOR suggesting backup.. taking a new backup everytime after successfully accomplishing above tasks in proper order.

*Hardly few MBs back* directly storing on server, naming appropriately.

Regards,

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

I tried to run the above query..

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

User2 = the username I am trying to change.

Getting following error:
#1146 - Table 'DBi_dbname.User2' doesn't exist

Not a techy to frame query or code.