MySQL in a Nutshell

Name

OLD_PASSWORD( )

Synopsis

OLD_PASSWORD(string)

This function encrypts a given string based on the password encryption method used prior to Version 4.1 of MySQL. The result is not decryptable.

UPDATE teachers
   SET pwd = OLD_PASSWORD('test')
   WHERE teacher_id = '730522';