The ENCRYPT() function uses one-way encryption algorithm, which means the
resulting hash cannot be "decrypted". If you want to compare a not crypted
value to a crypted one, you should also use ENCRYPT(), and compare the
hashes.
HTH,
Peter
On 18 Feb 2002, Amit Dilip Lonkar wrote:
>
> Hi
>
> Can anyone tell me if there is a function as "DECRYPT". If there is not, then how to
>decrypt a field which is Encrypted by the Mysql function "ENCRYPT".
>
> URGENT
>
> Thanks
> Amit Lonkar
>
>
--
GPG ID D40940EC
FPR 89CC E331 FFD0 3138 9CB2 FE0D 122E 9EC9 D409 40EC
---------------------------------------------------------------------
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
