How do I use MYSQL function in a UPDATE statement?

[resting]

I was doing a test with mysql. this is the code

update login set password=md5('aa') where login_id =1; 

The question is, password does not take the md5 value of 'aa'.
Possible to do it in 1 single SQL statement?

I know in PHP I can store the md5 value in a variable before passing as password="{$stored_md5}". Just curious about SQL statement.

[r937]

The question is, password does not take the md5 value of 'aa'.

it doesn't?

i got 4124bc0a9335c27f086f24ba207a4912 when i tested it

what do you get?

[resting]

4124bc0a9335c27f086f24ba207a4912 same...

weird..it works now...argh...but i'd already coded to store the md5 value in a variable first.

thanks for the effort =)

[PartDigital]

I would encourage you to adhere to this format

UPDATE login SET password = MD5('aa') WHERE login_id =1;

it makes it much easier to tell the difference between SQL functions/statements and fields/values