MD5

Reference material for MD5 function

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;

username text
c14fa496dfd5ebbb08aaca16a7c2781b

Rows: 1Execution time: 5.77ms