Mysql CRC32
From w3cyberlearnings
Contents |
MySQL CRC32 Function
This function returns a cyclic redundancy check value of a given string. It returns a 32 bit unsigned value.
Syntax CRC32
X is a string input.
CRC32(X);
Reference Link
http://en.wikipedia.org/wiki/Cyclic_redundancy_check
Example 1
mysql> SELECT CRC32('w3cyberlearnings.com');
+-------------------------------+
| CRC32('w3cyberlearnings.com') |
+-------------------------------+
| 3432908435 |
+-------------------------------+
1 row in set (0.00 sec)
Example 2
mysql> SELECT CRC32('great');
+----------------+
| CRC32('great') |
+----------------+
| 1234489951 |
+----------------+
1 row in set (0.00 sec)
