HASH
Computes the hash value of a text using a specified algorithm (MD5 or SHA-1)
Description
The HASH()
function allows you to calculate the hash value (checksum) of a text string using a specified cryptographic algorithm. This can be useful for data integrity checks or secure storage of sensitive information.
Syntax
HASH(”md5”/”sha1”, text
)
algorithm
: The cryptographic algorithm to use for hashing. It can be one of the following options:"md5"
or“sha1”
.text
: The input text string that you want to hash.
Example
Table
ID
Data
1
Hello, World!
2
Savant is awesome
3
12345
Function
HASH("md5",`Data`)
Results
HASH (text)
65a8e27d8879283831b664bd8b7f0ad4
83e999ae66b90fb41a69012b561e0f77
827ccb0eea8a706c4c34a16891f84e7b
Last updated