how to change password to md5

[pixeltrace]

hi,

 

i accidentally loaded a csv file and forgot to set the password fields to md5

 

what is the sql query that will change my password to md5?

 

like

UPDATE users SET password =md(password) WHERE password='123456'";

 

hope you could help me with this.

 

thanks!

[Caesar]

From phpmyadmin or whatever SQL command prompt/application you are using...

 

UPDATE `table` SET `password` = md5( 'password' ) ;

 

From PHP...

 

<?php

$db->query("UPDATE table SET password = md5( 'password' )") ;

?>