mt.executeQuery("SELECT * FROM users WHERE
user_name = '"+u_name+"' AND password = password('"+password+"') AND
STATUS = 'CURRENT'");
-Original Message-
From: Todd Williamsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002
From: "Peter Gibbons-BU" <[EMAIL PROTECTED]>
> Hi,
> i'd like to create a password field like in the user table in the mysql
> database. The data would need to be encrypted.
>
> Can mysql do the whole job. I would need it ideally to automatically
> decrypt it for me when I do a select..
>
> any
Peter,
I have no idea what your front end is, and this is what will do the
actual encryption, all mysql does is holds the data. So whatever your
front end programming language is, it will have to do the encryption.
Below is the link for php encryption
http://www.php.net/manual/en/function.md5
