Outdated Version

You are viewing an older version of this section. View current production version.


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

AES_ENCRYPT(ciphertext, key)


  • ciphertext: the binary data to decrypt
  • key: the text or binary key to use for decryption

Return Type

The “ciphertext” of encrypted data, in binary.


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

memsql> select hex(AES_ENCRYPT('secret message', 'ohai'));
| hex(AES_ENCRYPT('secret message', 'ohai')) |
| C958FF3BC0134ADE4A8F952338C1FAEC           |