Outdated Version
You are viewing an older version of this section. View current production version.
MD5
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 DB mainly for backwards compatibility and for systems which require a “good enough” hashing function and can tolerate collisions. For a more secure hash function, see SHA2.
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
