Function AES_DECRYPT does not exist . . .what??

[spudmurf2k]

Hi,

My MySQL installation has just told me that "#1305 - FUNCTION databasename.AES_DECRYPT does not exist" when I tried to run the following SQL "SELECT AES_DECRYPT(psword, 'user') FROM users" where the psword column is a blob. Why is it saying that?? Its infuriating me!! The AES_ENCRYPT() is running ok, and as far as I know that's the correct implementation of the function? Any clues much appreciaited. I'm running MySQL 5.0.15 on Windows XP Pro SP2.

[gmax]

I answered a similar question in a newsgroup.
Since I believe that this could be of general interest, I wrote about it in my blog.
http://datacharmer.blogspot.com/2005/12/function-wellknownfunc-does-not-exist.html

Ciao
gmax

[spudmurf2k]

so simple!!