MySQL Tutorial/Encryption Compression Functions/Introduction

Encryption and Compression Functions

Name Description AES_DECRYPT() Decrypt using AES AES_ENCRYPT() Encrypt using AES COMPRESS() Return result as a binary string DECODE() Decodes a string encrypted using ENCODE() DES_DECRYPT() Decrypt a string DES_ENCRYPT() Decrypt a string ENCODE() Encode a string ENCRYPT() Encrypt a string MD5() Calculate MD5 checksum OLD_PASSWORD() Return the value of the old (pre-4.1) implementation of PASSWORD PASSWORD() Calculate and return a password string SHA1(), SHA() Calculate an SHA-1 160-bit checksum UNCOMPRESS() Uncompress a string compressed UNCOMPRESSED_LENGTH() Return the length of a string before compression

Quote: dev.mysql.ru/doc/refman/5.1/en/index.html