Open In App
Related Articles

MySQL | MD5 Function

Improve Article
Improve
Save Article
Save
Like Article
Like

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 
Unlock the Power of Placement Preparation!
Feeling lost in OS, DBMS, CN, SQL, and DSA chaos? Our Complete Interview Preparation Course is the ultimate guide to conquer placements. Trusted by over 100,000+ geeks, this course is your roadmap to interview triumph.
Ready to dive in? Explore our Free Demo Content and join our Complete Interview Preparation course.

Last Updated : 08 Nov, 2019
Like Article
Save Article
Similar Reads