MD5

Calculate MD5 checksum. This function returns the MD5 hash of a string as a 32-character hexadecimal number.

Syntax

MD5(str)

Description

Calculates an MD5 128-bit checksum for the string.

The return value is a 32-hex digit string, and a nonbinary string in the connection character set and collation, determined by the values of the character_set_connection and collation_connection system variables.

NULL is returned if the argument was NULL.

Don't use this function as an encryption function.

MD5 can be used as a checksum to verify data integrity against unintentional corruption. Historically it was widely used as a cryptographic hash function; however it has been found to suffer from extensive vulnerabilities.

See https://en.wikipedia.org/wiki/MD5 for details.

Examples

SELECT MD5('testing');
+----------------------------------+
| MD5('testing')                   |
+----------------------------------+
| ae2b1fca515949e5d54fb22b8ed95575 |
+----------------------------------+

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}