Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
SHA1
On this page
Hashes the given string or binary data using the so-called secure hash algorithm, version 1.
It is present in SingleStore mainly for backwards compatibility and for systems which require a good enough
hashing function and can tolerate collisions.
Syntax
SHA1(plaintext)SHA(plaintext)
Arguments
-
plaintext: the data to hash.
Return Type
40 lower case hexadecimal digits corresponding to the 160-bit binary hash value.
Examples
SELECT SHA1('ohai'), SHA('ohai');
+------------------------------------------+------------------------------------------+
| SHA1('ohai') | SHA('ohai') |
+------------------------------------------+------------------------------------------+
| dca51952447d80bd35bf631bc21f06648798b7e0 | dca51952447d80bd35bf631bc21f06648798b7e0 |
+------------------------------------------+------------------------------------------+Related Topics
Last modified: February 27, 2023