Open In App

MySQL | MD5 Function

Improve
Improve
Like Article
Like
Save
Share
Report

The MySQL MD5 function is used to return an MD5 128-bit checksum representation of a string. The MD5 message-digest algorithm is a widely used hash function producing a 128-bit hash value. The value returned by the MD5 function is a binary string of 32 hexadecimal digits, or NULL if the argument was NULL.

The return value can also be used as a hash key. The MD5 function accepts one parameter which is the string to be encrypted.

Syntax:

MD5( plain_string )

Parameters Used:

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

Return Value:
The MD5 function in MySQL returns a binary string of 32 hexadecimal digits.

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 MD5 function on a string.

SELECT 
MD5('xyz'); 

Output:

d16fb36f0911f878998c136191af705e 

Example-2: Implementing MD5 function on a string with a combination of characters and integer values.

SELECT 
MD5('xyz123'); 

Output:

j89hj65l0355k878998c136191kl906w 

Example-3: Implementing MD5 function on a bigger string.

SELECT 
MD5('geeksforgeeks'); 

Output:

a6eb56f80be8a120436d6f1c9b8d87ca 

Example-4: Implementing MD5 function on a NULL string.

SELECT 
MD5('NULL'); 

Output:

NULL 

Last Updated : 08 Nov, 2019
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads