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






  1. SQL / MySQL
  2. Function
  3. MD5

SELECT MD5('a');

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

mysql>
mysql> SELECT MD5('A');
+----------------------------------+
| MD5('A')                         |
+----------------------------------+
| 7fc56270e7a70fa81a5935b72eacbe29 |
+----------------------------------+
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 LOWER(MD5('a'));
3.SELECT LOWER(MD5('a')) = UPPER(MD5('a'));