MySQL | SHA1( ) Function

The MySQL SHA1() function is used for encrypting a string using the SHA-1 technique. The SHA1 stands for secure hash algorithm and it produces a 160-bit checksum for a user inputted string. 

The MySQL SHA1() function returns NULL if the string passed as an argument is a NULL string. The SHA1() function accepts one parameter which is the string to be encrypted. 

Syntax:

SHA1(string)

Parameters Used:

string – It is used to specify the plain text string that is to be encrypted. 

Return Value:
The SHA1() function in MySQL returns the encrypted string or NULL if the string passed is an empty string. 

Supported Versions of MySQL:

• MySQL 5.7
• MySQL 5.6
• MySQL 5.5
• MySQL 5.1
• MySQL 5.0
• MySQL 4.1

Example-1: Implementing SHA1() function on a string. 

SELECT  
SHA1('geeksforgeeks'); 

Output:

69c9a5c19c5c27e43cb0efc4c8644ed6d03a110b 

Example-2: Implementing SHA1() function on a string which has a combination of characters and integers. 

SELECT 
SHA1('geeksforgeeks123'); 

Output:

53ce00666cbef425ab8d06ed652095bea20a1616 

Example-3: Implementing SHA1() function on a NULL string and returning the length of the string after compression. 

SELECT  
SHA1(NULL); 

Output:

NULL