Skip to content

MD5

Calculate the MD5 hash value for a character string and return the result in hexadecimal format.

MD5(string)

For example:

premdb=# SELECT DISTINCT MD5(ftscore) FROM match ORDER BY 1;
              md5                
----------------------------------
 0299c06aed970473ae41d986b308cd09
 0dd954ea204f19a1b391b7828491927b
 12426c956d1bc5017082b12a969b0b7c
 13cee27a2bd93915479f049378cffdd3
 17380ddb842e984302034e1bb66c24e4
 1981e4a762b39858dc33f9ea28ed065a
 19a1de167122a18af369c749f4e40a48
 20fdcfb87379c9a34b5ecbe0dda37ced
 2db0874cc1843a7520d8d5fc2f8e3f37
 2dd6b4185ffaf931647b896faa2467dd
 2f5bb7747efda0546636fb385a3fa593
...

Parent topic:String Functions