[Converting column to MD5 Hash]

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

 

Thanks Again!

[Converting column to MD5 Hash]

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!