AES_DECRYPT(crypt_str,key_str) : AES_DECRYPT : Encryption Compression Functions MySQL TUTORIALS

MySQL TUTORIALS » 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.


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>