Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.


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.




  • plaintext: the data to hash.

Return Type

32 lower case hexadecimal digits corresponding to the 128-bit binary hash value.


SELECT MD5('ohai');
| MD5('ohai')                      |
| 5a73678b7b674005056434a48054707d |

Related Topics