MySQL Tutorial/Encryption Compression Functions/AES DECRYPT

AES_DECRYPT(crypt_str,key_str)

AES_DECRYPT() decrypts the encrypted string and returns the original string.

Encoding with a 128-bit key length is used.

   <source lang="sql">

mysql> mysql> select AES_DECRYPT(AES_ENCRYPT("text","password"),"password") ; +--------------------------------------------------------+ | AES_DECRYPT(AES_ENCRYPT("text","password"),"password") | +--------------------------------------------------------+ | text | +--------------------------------------------------------+ 1 row in set (0.00 sec) mysql></source>