MD5()¶

MD5 () Function A widely used hash function that generates a 32-character long hexadecimal MD5 hash of a string.

Function Description¶

MD5 () Function A widely used hash function that generates a 32-character long hexadecimal MD5 hash of a string. It converts an input message of arbitrary length into a 128-bit (16-byte) hash, usually represented as a 32-bit hexadecimal string. Returns NULL if the argument is NULL.

Function syntax¶

> MD5(str)

Parameter interpretation¶

Parameters	Description
str	Required parameters. String to convert

Examples¶

mysql> select md5("hello world");
+----------------------------------+
| md5(hello world)                 |
+----------------------------------+
| 5eb63bbbe01eeed093cb22bb8f5acdc3 |
+----------------------------------+
1 row in set (0.00 sec)

mysql> select md5(null);
+-----------+
| md5(null) |
+-----------+
| NULL      |
+-----------+
1 row in set (0.00 sec)