Sometimes you only need a 32- or 64-bit hash function. One of my favorites at Yahoo and something we’re using at Fraudwall Technologies is the FNV (Fowler/Noll/Vo) Hash. If you’d like to use FNV inside of MySQL, you might find our udf_fnv.c useful. For example: mysql> select FNV1A_64(‘The quick brown fox jumps over the lazy […]