decrypt password()

[admin]

Hi,

I wanted to test the password() function in mysql and so update in a temporary database with this query -
update user set password = password(password)

This encrypted all the passwords for all users.

Now i want to decrypt these passwords. That is i want password "karthik" to be stored as "karthik" and NOT as "092jduu223213s".

How do i do this ?

Thanks,
Karthik.