MD5
On this page
Hashes the given string or binary data using the message digest algorithm, version 5.
MD5 has been strongly deprecated as a means of securely signing data, given the multiple weaknesses discovered in the algorithm.
It is present in SingleStore mainly for backwards compatibility and for systems which require a "good enough" hashing function and can tolerate collisions.
Syntax
MD5(plaintext)
Arguments
-
plaintext: the data to hash.
Return Type
32 lower case hexadecimal digits corresponding to the 128-bit binary hash value.
Examples
SELECT MD5('ohai');
+----------------------------------+
| MD5('ohai') |
+----------------------------------+
| 5a73678b7b674005056434a48054707d |
+----------------------------------+Related Topics
Last modified: May 3, 2023