Hashing functions provide a way to convert an arbitrary string into a (nearly) unique string of a known length, consisting of (nearly) random characters.
Function | Usage and description |
SHA1 |
Usage: FUNC_SHA1(string) This function uses the SHA1 cryptographic hash function to convert a variable-length string into a 40-character string. The new string is a text representation of the hexadecimal value of a 160-bit checksum. |
MD5 |
Usage: MD5(string) Returns a string of length 32 that represents the MD5 hash of the input string. |