Michael J. Radwin's blogTales of a software engineer who keeps kosher and hates the web.MySQL User Defined Functions for FNV (FowlerNollVo) Hash- March 28, 2007 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 (FowlerNollVo) 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 dog.'); +----------------------------------------------------------+ FNV1A_64('The quick brown fox jumps over the lazy dog.')...http://www.radwin.org/michael/blog/2007/03/mysql_user_defined_functio.html |