Use CRC32 to compute the result.
BIGINT crc32 (VARCHAR str)
Returns the Cyclic Redundancy Check value of this string.
mysql> select crc32("abc"); +--------------+ | crc32('abc') | +--------------+ | 891568578 | +--------------+
CRC32