mysql Encryption and Compression Functions

Name	Description	Deprecated
AES_DECRYPT()	Decrypt using AES
AES_ENCRYPT()	Encrypt using AES
COMPRESS()	Return result as a binary string
DECODE()	Decode a string encrypted using ENCODE()	Yes
DES_DECRYPT()	Decrypt a string	Yes
DES_ENCRYPT()	Encrypt a string	Yes
ENCODE()	Encode a string	Yes
ENCRYPT()	Encrypt a string	Yes
MD5()	Calculate MD5 checksum
PASSWORD()	Calculate and return a password string	Yes
RANDOM_BYTES()	Return a random byte vector
SHA1(), SHA()	Calculate an SHA-1 160-bit checksum
SHA2()	Calculate an SHA-2 checksum
UNCOMPRESS()	Uncompress a string compressed
UNCOMPRESSED_LENGTH()	Return the length of a string before compression
VALIDATE_PASSWORD_STRENGTH()	Determine strength of password