MD5_NUMBER_LOWER64
Represent the lower 64 bits of the MD5 hash value of the input string as BIGINT
.
Syntax
MD5_NUMBER_LOWER64(<string>)
Parameter | Description |
---|---|
<string> | The string to calculate the MD5 hash value on and represent as BIGINT. |
Example
SELECT
MD5_NUMBER_LOWER64('test') AS res;
Returns: 14618207765679027446