Link Search Menu Expand Document

MD5

Calculates the MD5 hash of string, returning the result as a string in hexadecimal.

Syntax

MD5(<expression>)

Parameters

Parameter Description Supported input types
<expression> The string to hash. TEXT

Return Types

  • Returns TEXT with string input
  • Returns NULL if input is NULL

Example

The following example returns the username esimpson in hexadecimal:

SELECT
	MD5('esimpson') AS username;

Returns: c14fa496dfd5ebbb08aaca16a7c2781b