----- Original Message -----
From: "Zach Curtis" <[EMAIL PROTECTED]>
> an encrypted PASSWORD('password') field in the MySQL table. How can I
> retrieve the decrypted password in a SELECT statement?MySQL's password() function is a one way hash. It does not have a decryption function. Regardless, a better solution is to change the user's password to a random string, then e-mail the user their new password. Hope this helps, Ryan Fox --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
