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.

Examples

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

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