MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE `hashes` (
  `id` int(11) NOT NULL,
  `hash` binary(8) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
INSERT INTO `hashes` (`id`, `hash`) VALUES
(1, 0xb1d0c44a4eb5b5a9),
(2, 0x1f69f25228ed4a31),
(3, 0x751a0b19f0c2783f);
SELECT HEX(h.`hash`) as hh, BIT_COUNT(h.`hash` ^ 0x751a0b19f0c2783f) bc 
FROM hashes h


hh
bc


B1D0C44A4EB5B5A9
38

1F69F25228ED4A31
34

751A0B19F0C2783F
0