MD5

All functions > STRING > MD5

Returns the MD5 hash of a string as a 32-character hexadecimal string.

Signatures

Returns: 32-character lowercase hexadecimal MD5 hash

MD5(string: VARCHAR) → VARCHAR

Notes

• Returns a 128-bit hash as a 32-character lowercase hex string
• Deterministic: same input always produces the same hash
• Not suitable for security-sensitive applications; use SHA256 instead
• Returns NULL if the input is NULL

Examples

SELECT
    f1 := MD5('ABC'),  -- Hash of uppercase string
    f2 := MD5('hello'),  -- Hash of lowercase string
    f3 := MD5('')  -- Hash of empty string
;