I’m looking for a way to UPDATE a table to MD5() all my stored passwords.
I was hoping a simple subquery passed to the MD5 method would be all it would take.
UPDATE users SET id = MD5((SELECT id FROM users))
No such luck.
Any advice?
I’m looking for a way to UPDATE a table to MD5() all my stored passwords.
I was hoping a simple subquery passed to the MD5 method would be all it would take.
UPDATE users SET id = MD5((SELECT id FROM users))
No such luck.
Any advice?
UPDATE users SET id = MD5(id)
But you really should use a salt to make the MD5 more secure.
Thank you for that super fast reply. Note taken on the salt.
Are you trying to MD5 your user’s ID, or the password field?