MD5

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

Syntax

MD5(<expression>)

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

The following example returns the username esimpson in hexadecimal:

SELECT MD5('esimpson') AS username;

username text
c14fa496dfd5ebbb08aaca16a7c2781b

Rows: 1Execution time: 5.77ms

⌘I