Converting column to MD5 Hash

[PHP_Joker]

Hi all,

 

I want to convert my existing SQL password column (currently in text) to MD5. Anyone have a trick for this? I tried a code I thought would work, but it doesn\'t give me enough characters in the new MD5 password.

 

Here is the code I used:

 

update mytable

set mycolumn = md5(mycolumn);

 

Thanks for your help!

[effigy]

that sql will work. you need to alter that table column to hold a larger number of characters.

[PHP_Joker]

Thank you for pointing out an obvious oversight on my part effigy! I will get the hang of this eventually!

 

Thanks Again!