Re: function use in sql -- md5

Hi Philip! Don't forget your WHERE clause, otherwise you will update your whole table with that one value. But, I've never used the MD5() mysql function, I don't know if that part will work. I always tend to write little php scripts to handle the job. That way, I can minimize the CPU required on my single DB server and try and keep all the CPU intensive stuff on my workstation. :) -jeremy http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for more --------------------------------------------------------------------- We cannot do everything at once, but we can do something at once. -- Calvin Coolidge On Wed, 15 Nov 2000, Philip Olson wrote: > Date: Wed, 15 Nov 2000 02:35:57 +0000 (GMT) > From: Philip Olson <philip@theprojects.org> > To: php-general@lists.php.net > Subject: [PHP] function use in sql -- md5 > > Hi friends! > > 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 similar 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 (after setting (32) : > > 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 General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >