Look in the manual about the ENCODE/DECODE functions.
j----- k-----
On Friday 08 June 2001 10:28, you wrote:
> Hello all,
>
> I have some questions about password encryption. I want to make some sort
> of encryption method that disables a human to read the password, but does
> allow my (php) script to convert the encoded password to a human-readable
> password, the member originally entered and the member enters in the form
> (if he or she has the password right) .
>
> In other words, I want a string to be encrypted and decrypted, if it's
> possible in the query.
>
> An example:
>
> insert into table values (encrypt("secret"));
> select decrypt(passfield) as pass from table;
>
> and here, pass will contain the value of "secret".
--
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601
---------------------------------------------------------------------
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