Query Error (AES_ENCRYPT) 1

[degroat]

I havae a user database set up where the passwords are encrypted using AES_ENCRYPT with the date the user joined being the salt for each user. The inserts work fine for the password, but for some reason I'm getting an error on this statement below when I try to update....

update users set password = AES_ENCYPT('123456', '2005-09-15 22:11:06') where user_id = '806'

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('123456', '2005-09-15 22:11:06') where user_id = '806'' at line 1

Any idea what is going on here?

BTW... the password field is set up as a BLOB.

 

[TonyGroves]

Should that not be AES_ENCRYPT ?

 

[degroat]

Son of a....

I knew it was going to end up being something stupid.

Thanks