md5() entire column

[ktai]

Hi,
I have a new mysql database with a few hundred records. Right now every password (in the password field) is stored in plaintext. Is there an easy way to convert every record in the 'password' field to MD5? I know I can use the phpmyadmin command line to convert each record one-by-one, but as you can imagine I do not want to do that.
Thanks!

 

[sleipnir214]

UPDATE tablename SET columname = md5(columnname)

should do it.

I'd also recommend not using "password" as a columnname. It is a MySQL reserved word.


Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[ktai]

Perfect! Thanks again.