Mega Code Archive

 

Categories / MySQL / Function

 

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>