Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

AES_ENCRYPT

Encrypts the given ciphertext using the AES (Advanced Encryption Standard) algorithm, with a 128-bit key.

Syntax

AES_ENCRYPT(ciphertext, key)

Arguments

  • ciphertext: the binary data to encrypt
  • key: the text or binary key to use for encryption

Return Type

The “ciphertext” of encrypted data, in binary.

Examples

Note: the HEX function is used in this example to make it easier to handle binary data.

SELECT HEX(AES_ENCRYPT('secret message', 'ohai'));
+--------------------------------------------+
| HEX(AES_ENCRYPT('secret message', 'ohai')) |
+--------------------------------------------+
| C958FF3BC0134ADE4A8F952338C1FAEC           |
+--------------------------------------------+

Related Topics