id username password 1 testuser testpass update mytable set password=md5(password); id username password 1 testuser 179ad45c6ce2cb97cf1029e212046e81