At 8:09 AM -0600 9/20/03, Stout, Jeff wrote:
Thanks John, I'm trying various syntax changes but still getting
Empty set
mysql> INSERT INTO user_profile (userid,password)
-> VALUES ("James",AES_ENCRYPT("bond","007"));
Query OK, 1 row affected (0.00 sec)
mysql> SELECT * FROM user_profile WHERE us
> SELECT username, AES_DECRYPT(password,"sydo89") AS psw
> FROM user_profile
> WHERE personid=1
retrieves the username and the clear password
regards
benny
- Original Message -
From: "Stout, Jeff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent:
WHERE userid="james" AND
-> AES_DECRYPT("password","bond")="007";
Empty set (0.00 sec)
-Original Message-
From: John Hopkins [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 6:38 PM
To: Stout, Jeff
Subject: RE: Data store/extract help a
I'm still unclear on how to do the decrypt syntax,
forgive me I'm new to DB work, my background is
more security and UNIX admin.
I need help with the data extraction/decryption
SELECT userid, password
FROM user_profile AES_DECRYPT("user","password")
??
What I'm trying to accomplish is I'm u
