Encryption Functions

Encryption functions encrypt or decrypt VARCHAR or BINARY values.

Function

Notes

ENCRYPT

Encrypts VARCHAR or BINARY values using a passphrase.

DECRYPT

Decrypts VARCHAR or BINARY values using a passphrase.

ENCRYPT_RAW

Encrypts BINARY values using a binary key and an initialization vector.

DECRYPT_RAW

Decrypts BINARY values using a binary key and an initialization vector.