Thursday, January 5, 2012

Change a database field to md5 hash

Change all entrys of a fild in a database table to md5 hash,
this sql string works fine:
UPDATE tablename SET fieldname = MD5(fieldname)

Useful for a table with adresses, where the password should be converted.

No comments:

Post a Comment