md5 encoding

[cs1h]

Hi,

 

I have a table in mysql with codes in one column, I would now like to convert the codes to be md5 hashed. Is there a way to do it in one go (because I have about 1000 entries) so I don't have to go through them all one by one.

 

Any help will be appreciated.

 

Thanks,

Colin

[Fadion]

I can't think of an automated way. What i can suggest is using a similar script:

 

<?php
$results = mysql_query("SELECT id, code FROM table");
while($values = mysql_fetch_array($results)){
     $code = md5($values['code']);
     $id = $values['id'];
     $resultsUpdate = mysql_query("UPDATE table SET code='$code' WHERE id=$id");
}
?>

[Mchl]

UPDATE table SET code = MD5(code);

[Fadion]

UPDATE table SET code = MD5(code);

 

lol. ok that is definitely better