Encrypt Data Already Stored in DB

Databases
1

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?

2 
UPDATE users SET id = MD5(id)

But you really should use a salt to make the MD5 more secure.

3

Thank you for that super fast reply. Note taken on the salt.

4

Are you trying to MD5 your user’s ID, or the password field?