Your query seems OK, but it might be your password field. Maybe you have to
use ``
SELECT AES_DECRYPT(`password`, 'fff') AS `password_dec` FROM `table_name`
WHERE `user_id` = '555'
just a guess anyway... Tiago
On 5/25/07, Mark Wheeler <[EMAIL PROTECTED]> wrote:
>
> 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
>
>
[Non-text portions of this message have been removed]
