[PHP-DB] functions in sql statements - such as md5 From: Philip Olson (philip <email protected>)
Date: 11/14/00

Hi!

I have a mysql column full of plain text passwords that I'd like to hash
via MD5. I can think of looping through and updating through php but am
hoping to learn a little trick to speed up such activities in the future.
All thoughts and tips welcome for updating, ideally at the shell level
which is one of my current weaknesses. This will not work but is the
idea :

update mycolumn
set mycolumn = md5("mycolumn");
                               
What would be proper syntax to complete this goal? How would YOU approach
this?

TIA,

Philip 

--
be outside the box.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>