Hi, I'm beating my head against a wall here. I can not figure out where the syntax error is! Can anyone give me a helpful hint, please? Here's how I encrypted it and how I am trying to decrypt it.
INSERT INTO table_name VALUES ('555',AES_ENCRYPT('abcdefg', 'fff'))
SELECT AES_DECRYPT(password, 'fff') AS password_dec FROM table_name
WHERE user_id = 555
I don't get an error when inserting (or updating) but when I try to
decrypt, I get a syntax error. Where is it?
Thanks very much for any help,
Mark
