Skip to main content

SIPHASH

Produces a 64-bit SipHash hash value.

Syntax

siphash(expression)
siphash64(expression)

Arguments

ArgumentsDescription
expressionAny 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') |
+-----------------------+
| 18110648197875983073 |
+-----------------------+

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

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

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