Use the MD5() function to create a 128-bit encrypted value: MD5() : MD5 « Function « SQL / MySQL






Use the MD5() function to create a 128-bit encrypted value: MD5()

    
mysql>
mysql>
mysql> SELECT MD5('MyPassword');
+----------------------------------+
| MD5('MyPassword')                |
+----------------------------------+
| 48503dfd58720bd5ff35c102065a52d7 |
+----------------------------------+
1 row in set (0.00 sec)

mysql>

   
    
    
    
  








Related examples in the same category

1.SELECT MD5('a');
2.SELECT LOWER(MD5('a'));
3.SELECT LOWER(MD5('a')) = UPPER(MD5('a'));