Erick Stohr writes:
> Hello, I am using the password('mypassword') function to store
> passwords, my question now is how do I pull the password un-encrypted?
> Is that possible? Just looking for the SQL SELECT statement. Running
> MySQL ofcourse. Thanks.

Nope. Like Bob said, password() is a one-way encryption.

If you're looking for two-way to use in your application, check out
the encode()/decode() duo.

   http://www.mysql.com/doc/M/i/Miscellaneous_functions.html

You have to then make sure to keep the encoding password secure.


Regards,

    Matt

-- 
For technical support contracts, visit https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Matt Wagner <mwagner at mysql.com>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Herr Direktor
/_/  /_/\_, /___/\___\_\___/   Hopkins, Minnesota  USA
       <___/   www.mysql.com