MD5 in mysql - PHPBuilder Forums

PHP Help PHP Databases
MD5 in mysql

SSawan
Feb 25, 2006
Post #1 Saturday, February 25, 2006 4:10 PM

Hi
I have a php script, and a mysql databse.
I will be moving the dbase to a new script.
Is there a sql command to md5 encrypt all the records in one column(password), once it has been uploaded.

Bbradgrafelman
Feb 26, 2006
Post #2 Sunday, February 26, 2006 1:41 AM

Sure. Simply use the MD5() function in MySQL like so:

UPDATE `table` SET `password` = MD5(`password`)

Write a Reply...

MD5 in mysql

Sawan

Hi
I have a php script, and a mysql databse.
I will be moving the dbase to a new script.
Is there a sql command to md5 encrypt all the records in one column(password), once it has been uploaded.

bradgrafelman

Sure. Simply use the MD5() function in MySQL like so:

UPDATE `table` SET `password` = MD5(`password`)