Skip to content

Instantly share code, notes, and snippets.

@ghafran
ghafran / MurmurHashV2.sql
Last active December 11, 2022 11:20
MySQL Function to Calculate Murmur Hash Murmurhash (MurmurHashV2)
DROP FUNCTION IF EXISTS MurmurHashV2;
DELIMITER //
CREATE FUNCTION `MurmurHashV2`(`keyx` varchar(65535), `seed` int unsigned)
RETURNS int unsigned
BEGIN
DECLARE l,i,m,r INT unsigned;
DECLARE h,k BIGINT unsigned;
SET l = LENGTH(keyx), i=1, m = 0x5bd1e995, r=24;
SET h = seed ^ l;