password security

Hi,

I use the PASSWORD function to encrypt the password provided by the users in a registration form in my site.

The problem is that the password is encrypted and stored. I am not able to decrypt it whenever I require it.With use of Password func how do I decrypt it?

Thanks in advance

There is no complement to the password() function for decrypting.

Instead of decrypting password,
you can encrypt another password by
using PASSWORD() .
ex) select PASSWORD('another_one');

Or, check the rows what is correct.
ex) select id from MEMBER_TABLE where password = PASSWORD('another_one');

Hi Paxjesus and others.

I'm a newbie to mysql, php and so on, but I'm getting the basic idea, BUT..
is it then tru if the simpel line:
PASSWORD('another_one');
Encrypts the "another_one" string?
how can this be?

password() is just a built in function of mysql that uses a propriety system to encrypt the string passed. No magic to it.