Encryption, Hashing and Compression Functions

Encryption, hashing and compression functions, such as ENCRYPT, DECRYPT, COMPRESS, PASSWORD etc.

Title Description
AES_DECRYPT Decryption data encrypted with AES_ENCRYPT
AES_ENCRYPT Encrypts a string with the AES algorithm.
COMPRESS Returns a binary, compressed string.
DECODE Decrypts a string encoded with ENCODE(), or, in Oracle mode, matches expressions.
DES_DECRYPT Decrypts a string encrypted with DES_ENCRYPT().
DES_ENCRYPT Encrypts a string using the Triple-DES algorithm.
ENCODE Encrypts a string.
ENCRYPT Encrypts a string with Unix crypt().
MD5 MD5 checksum.
OLD_PASSWORD Pre MySQL 4.1 password implementation.
PASSWORD Calculates a password string.
SHA1 Calculates an SHA-1 checksum.
SHA2 Calculates an SHA-2 checksum.
UNCOMPRESS Uncompresses string compressed with COMPRESS().
UNCOMPRESSED_LENGTH Returns length of a string before being compressed with COMPRESS().
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/encryption-hashing-and-compression-functions/