Skip to main content

MD5

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.

Syntax

md5(expression)

Arguments

ArgumentsDescription
expressionThe string value.

Return Type

A String data type hash value.

Examples

SELECT MD5('1234567890');
+----------------------------------+
| MD5('1234567890') |
+----------------------------------+
| e807f1fcf82d132f9bb018ca6738a19f |
+----------------------------------+