SIPHASH

Produces a 64-bit SipHash hash value.

Syntax

siphash(expression)
siphash64(expression)

Arguments

Arguments	Description
expression	Any expression. This may be a column name, the result of another function, or a math operation.

Return Type

A UInt64 data type hash value.

Examples

mysql> SELECT SIPHASH('1234567890');
+---------------------+
| SIPHASH(1234567890) |
+---------------------+
| 9027491583908826579 |
+---------------------+

mysql> SELECT SIPHASH(1);
+---------------------+
| SIPHASH(1)          |
+---------------------+
| 2206609067086327257 |
+---------------------+

mysql> SELECT SIPHASH(1.2);
+---------------------+
| SIPHASH(1.2)        |
+---------------------+
| 2854037594257667269 |
+---------------------+

mysql> SELECT SIPHASH(number) FROM numbers(2);
+----------------------+
| siphash(number)      |
+----------------------+
| 13646096770106105413 |
|  2206609067086327257 |
+----------------------+