SHA1

Declaration

SHA1(str)

Description

Computes and returns the SHA-1 160-bit checksum of the given string. The value is returned as a string of 40 hexadecimal digits. Equivalent to the SHA() function.

Example

SELECT SHA1('OB');
+------------------------------------------+
| SHA1('OB')                               |
+------------------------------------------+
| 29a6de2fd8618f31afb281a608c57995b7eb105d |
+------------------------------------------+
1 row in set (0.001 sec)