MD5_NUMBER_LOWER64

Represent the lower 64 bits of the MD5 hash value of the input string as BIGINT.

Syntax

MD5_NUMBER_LOWER64(<expression>)

Parameter	Description	Supported input type
`<expression>`	The string to calculate the MD5 hash value on and represent as `BIGINT`	`TEXT`

BIGINT

The following example represents the username esimpson as a BIGINT:

SELECT MD5_NUMBER_LOWER64('esimpson') AS username;

username Decimal(38, 0)
624533696996866075

Rows: 1Execution time: 5.42ms

⌘I