Mega Code Archive

 

Categories / MySQL Tutorial / Encryption Compression Functions

 

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>