aes_decrypt.md

description
Decrypts a string produced by AES encryption.

AES_DECRYPT

Syntax

AES_DECRYPT(ciphertext varchar, key varchar) → varchar

• ciphertext: The string to be decrypted.
• key: The key to use to decrypt the ciphertext.

Examples

{% code title="AES_DECRYPT example" %}

SELECT AES_DECRYPT(UNBASE64('Fad52k2P1Y6rMZ0DBcg8SQ=='), 'mypassword')
-- Spice

{% endcode %}