Jump to content

Archived

This topic is now archived and is closed to further replies.

PHP_Joker

Converting column to MD5 Hash

Recommended Posts

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!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

 

Thanks Again!

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.