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






  1. SQL / MySQL
  2. Function
  3. MD5

SELECT LOWER(MD5('a')) = UPPER(MD5('a'));

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

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

mysql>








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'));