MD5(str)

MySQL 8.4

Calculates an MD5 128-bit checksum for the string. The value is returned as a string of 32 hexadecimal digits, or NULL if the argument was NULL. The return value can, for example, be used as a hash key. See the notes at the beginning of this section about storing hash values efficiently.

Syntax

MYSQL

SELECT MD5('testing');
'ae2b1fca515949e5d54fb22b8ed95575'

Examples

Example

The return value is a string in the connection character set.

MYSQL

SELECT MD5('testing');
'ae2b1fca515949e5d54fb22b8ed95575'