MySQL in a Nutshell

Name

AES_ENCRYPT( )

Synopsis

AES_ENCRYPT(string, password)

This function returns encrypted text using the AES algorithm with a 128-bit key length and returns NULL if one of the given parameters is NULL. The results of this function can be reversed with AES_DECRYPT( ). This function is available as of Version 4.0.2 of MySQL.

UPDATE teachers
   SET personal = AES_ENCRYPT('text', 'my_password')
   WHERE teacher_id = '730522';