MySQL in a Nutshell

Name

AES_DECRYPT( )

Synopsis

AES_DECRYPT(string, password)

This function decrypts text that was encrypted using the AES algorithm with a 128-bit key length, and it returns NULL if one of the given parameters is NULL. This function reverses the AES_ENCRYPT() function. This function is available as of Version 4.0.2 of MySQL.

SELECT AES_DECRYPT(personal, 'my_password') AS Personal
   FROM teachers
   WHERE teacher_id='730522';
+----------+
| Personal |
+----------+
| text     |
+----------+

In this example, the value for the personal column is decrypted using the password given. The result is just the plain text.