hi all... i found this on the mysql dev manual site: "MySQL 4 and later string comparisons, including DISTINCT, aren't case sensitive unless the field is declared as BINARY or you use BINARY in your comparison."
so here i tried it but no good. any ideas?! the field is not declared binary but i do have 'binery' in my select. is it in the wrong place?! thanks.... mysql> select binary code from promo_codes where code = "USAW2umHv7De"; +--------------+ | binary code | +--------------+ | USAW2umHv7De | +--------------+ 1 row in set (0.02 sec) mysql> select binary code from promo_codes where code = "USAW2umHv7DE"; +--------------+ | binary code | +--------------+ | USAW2umHv7De | +--------------+ 1 row in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
