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