On Wed, 3 Sep 2003 00:14:42 -0300 "Fernando (BOL)" <[EMAIL PROTECTED]> wrote:
> Hi, > > Can anyone tell me which function have more security/encryption? > PASSWORD( ) ? > ENCODE( ) ? > MD5( ) ? Please, read http://www.mysql.com/doc/en/Miscellaneous_functions.html PASSWORD & MD5 are realizations of hashing algorithms (you can't get original data from the hash), while ENCODE encrypts string, using some password and can be decrypted using the same password string. There is no need to use ENCODE in case of storing passwords, instead you can use MD5 and queries like this: SELECT * FROM users WHERE MD5('password_entered_by_user')=hashed_password_field_from_database; --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]