murmur_hash3_32

description

Syntax

INT MURMUR_HASH3_32(VARCHAR input, ...)

返回输入字符串的32位murmur3 hash值

example

  1. mysql> select murmur_hash3_32(null);
  2. +-----------------------+
  3. | murmur_hash3_32(NULL) |
  4. +-----------------------+
  5. |                  NULL |
  6. +-----------------------+
  8. mysql> select murmur_hash3_32("hello");
  9. +--------------------------+
  10. | murmur_hash3_32('hello') |
  11. +--------------------------+
  12. |               1321743225 |
  13. +--------------------------+
  15. mysql> select murmur_hash3_32("hello", "world");
  16. +-----------------------------------+
  17. | murmur_hash3_32('hello', 'world') |
  18. +-----------------------------------+
  19. |                         984713481 |
  20. +-----------------------------------+

keyword

  1. MURMUR_HASH3_32,HASH