md5()

Returns the MD5 hash of the blob as a VARCHAR.

Arguments & returns

2 overloads

Scalar

Overload link	`blob`	Returns
#01	`BLOB`	`VARCHAR`

Scalar

Returns the MD5 hash of the string as a VARCHAR.

Overload link	`string`	Returns
#02	`VARCHAR`	`VARCHAR`

SELECT md5('\xAA\xBB'::BLOB);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT md5('abc');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT TO_HEX(MD5(some_string))

In DuckDB

SELECT MD5(some_string)