Function MySQL

  1. Home
  2. MySQL
  3. Function
  4. 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>