MySQL in a Nutshell, 2nd Edition

Name

CRC32()

Synopsis

CRC32(string)

This function returns the given string’s cyclic redundancy check (CRC) value as a 32-bit unsigned value. It’s available as of version 4.1 of MySQL. It returns NULL if given a NULL value. Even if a numeric value is given, it treats the value as a string:

SELECT CRC32('test');

+---------------+
| CRC32('test') |
+---------------+
|    3632233996 |
+---------------+