SHA1 , SHA1_HEX
This function has no corresponding decryption function. (The length of the output is independent of the length of the input. The output does not necessarily have enough bits to hold all of the information from the input, so it is not…
DECRYPT
Decrypts a BINARY value using a VARCHAR passphrase.
SHA2 , SHA2_HEX
This function has no corresponding decryption function. (The length of the output is independent of the length of the input. The output does not necessarily have enough bits to hold all of the information from the input, so it is not…
SHA1_BINARY
This function has no corresponding decryption function. (The length of the output is independent of the length of the input. The output does not necessarily have enough bits to hold all of the information from the input, so it is not…
SHA2_BINARY
This function has no corresponding decryption function. (The length of the output is independent of the length of the input. The output does not necessarily have enough bits to hold all of the information from the input, so it is not…
All functions (alphabetical)
ABS Returns the absolute value of a numeric expression. Numeric functions ACOS Computes the inverse cosine (arc cosine) of its input; the result is a number in the interval [0, pi].
Encryption functions
…encrypt or decrypt VARCHAR or BINARY values. Function Notes ENCRYPT Encrypts VARCHAR or BINARY values using a passphrase. DECRYPT Decrypts VARCHAR or BINARY values using a passphrase.
HASH
The cryptographic hashing of a value cannot be inverted to find the original value. Given a value, it is infeasible to find another value with the same cryptographic hash. For cryptographic purposes, use the SHA families of functions (in…
MD5 , MD5_HEX
Returns a 32 - character hex - encoded string containing the 128 - bit MD5 message digest. These functions are synonymous.
TRY_DECRYPT
A special version of DECRYPT that returns a NULL value if an error occurs during decryption.
Source