comparehash

A bitwise XOR of two big Integers. Returns the difference in percent.
/* MYSQL QUERY */ SELECT ((64 - bit_count(hash1 ^ hash2))*100.0/64); /* MYSQL Function */ DELIMITER $$ DROP FUNCTION IF EXISTS comparehash $$ CREATE FUNCTION comparehash (hash1 bigint, hash2 bigint) RETURNS float DETERMINISTIC BEGIN RETURN ((64 - bit_count(hash1 ^ hash2))*100.0/64); END $$ DELIMITER ;

Url: http://www.medienservice-ladewig.de/MYSQL-Hamming-Distance.2099932101.html

Language: SQL | User: J√∂rg | Created: Oct 21, 2013 | Tags: mysql bitwise xor function