SELECT LOWER(MD5('a')); : MD5 « Function « SQL / MySQL






SELECT LOWER(MD5('a'));

    
mysql>
mysql> SELECT LOWER(MD5('a'));
+----------------------------------+
| LOWER(MD5('a'))                  |
+----------------------------------+
| 0cc175b9c0f1b6a831c399e269772661 |
+----------------------------------+
1 row in set (0.00 sec)

   
    
    
    
  








Related examples in the same category

1.Use the MD5() function to create a 128-bit encrypted value: MD5()
2.SELECT MD5('a');
3.SELECT LOWER(MD5('a')) = UPPER(MD5('a'));