CRC32

Returns the CRC32 checksum of a string.

Syntax

CRC32(x)

Arguments

Arguments	Description
x	The argument is expected to be a string and (if possible) is treated as one if it is not.

Return Type

UInt32.

Examples

mysql> SELECT CRC32('MySQL');
+----------------+
| CRC32('MySQL') |
+----------------+
|     3259397556 |
+----------------+
1 row in set (0.09 sec)

mysql> SELECT CRC32('mysql');
+----------------+
| CRC32('mysql') |
+----------------+
|     2501908538 |
+----------------+
1 row in set (0.01 sec)

mysql> SELECT CRC32(NULL);
+-------------+
| CRC32(NULL) |
+-------------+
|        NULL |
+-------------+
1 row in set (0.00 sec)

mysql> SELECT CRC32(12);
+------------+
| CRC32(12)  |
+------------+
| 1330857165 |
+------------+
1 row in set (0.01 sec)