SHA1(str), SHA(str) calculates an SHA-1 160-bit checksum for the string. : SHA « Encryption Compression Functions « MySQL Tutorial






mysql>
mysql> SELECT SHA1('abc');
+------------------------------------------+
| SHA1('abc')                              |
+------------------------------------------+
| a9993e364706816aba3e25717850c26c9cd0d89d |
+------------------------------------------+
1 row in set (0.00 sec)

mysql>








19.14.SHA
19.14.1.SHA1(str), SHA(str) calculates an SHA-1 160-bit checksum for the string.
19.14.2.Using the SHA function with first name