AES_DECRYPT

Syntax

AES_DECRYPT(crypt_str,key_str[,init_vector])

Description

AES_DECRYPT returns the plaintext of the ciphertext crypt_str using the key key_str.

For more information about the init_vector parameter, see AES_ENCRYPT.

Examples

SELECT AES_DECRYPT(AES_ENCRYPT('oceanbase',UNHEX('F3229A0B371ED2D9441B830D21A390C3')),UNHEX('F3229A0B371ED2D9441B830D21A390C3'));
+---------------------------------------------------------------------------------------------------------------------------+
| AES_DECRYPT(AES_ENCRYPT('oceanbase',UNHEX('F3229A0B371ED2D9441B830D21A390C3')),UNHEX('F3229A0B371ED2D9441B830D21A390C3')) |
+---------------------------------------------------------------------------------------------------------------------------+
| oceanbase                                                                                                                 |
+---------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.001 sec