AES_ENCRYPT

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

Syntax

AES_ENCRYPT(plaintext, key)

Arguments

  • plaintext: the binary string data to encrypt

  • key: the text or binary string key to use for encryption

Return Type

The ciphertext of encrypted data, in binary.

Remarks

  • Encryption Algorithm: AES

  • Key Size: 128 bit

  • Operation Mode: ECB mode: Electronic Code Book mode

  • IV (initialization vector): Not used

Examples

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

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

Related Topics