Mega Code Archive

 

Categories / MySQL / Function

 

To create a 160-bit encrypted value based on a specified string, you can use the SHA() or SHA1() functions

mysql> mysql> SELECT SHA('MyPassword'); +------------------------------------------+ | SHA('MyPassword')                        | +------------------------------------------+ | daa1f31819ed4928fd00e986e6bda6dab6b177dc | +------------------------------------------+ 1 row in set (0.00 sec) mysql>