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