MD5_NUMBER_LOWER64
Represent the lower 64 bits of the MD5 hash value of the input string as BIGINT.
Syntax
MD5_NUMBER_LOWER64(<expression>)
Parameters
| Parameter | Description | Supported input type |
|---|---|---|
<expression> | The string to calculate the MD5 hash value on and represent as BIGINT | TEXT |
Return Type
BIGINT
Example
The following example represents the username esimpson as a BIGINT:
SELECT
MD5_NUMBER_LOWER64('esimpson') AS username;
Returns: 624,533,696,996,866,075