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)

  1. algorithm: The cryptographic algorithm to use for hashing. It can be one of the following options: "md5" or “sha1”.

  2. 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