[SOLVED] MD5 a whole Column?

[Epidemic]

Hey,

 

I have got an old username and password database for my users of my websites. However when I first made my website I didn't know about MD5 encryption, but I now do. However I want to MD5 all of there passwords in my members table. Is there any SQL query I can use to MD5 all the passwords in the passwords collum?

 

I really do hope there is because otherwise I have 200 + passwords to MD5.

 

Josh

[dropfaith]

not that i ever recall learning but you could use a php script to pull them all out at once md5 and resubmit them to the db

 

i think at least hrmm

[Mchl]

UPDATE users SET password = MD5(password);

 

But before you do it. Did you think about salting your passwords?

[Epidemic]

No, what is salting?

[Mchl]

Salt is basically a string of random character you add to each password, so that decrypting it was more difficult. (See Wikipedia article for more)