Hashing Functions

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.