Let's say I have some fake or spam users, and I would like to change the password of those accounts to one single new password.
For simplicity, I'd like to change password of those whose userid > 100.
I know that I may need some MySQL queries like:
UPDATE qa_users SET password =???? WHERE userid > 100
But I don't know how to make those passwords hashed or encrypted.
What are the extra steps I need to do?