When you think about how many people would be asking how to make them
case-insensitive versus how many need to perform case-sensitive
searching, it makes sense to me.
Todd Boyd
Web Programmer
-Original Message-
From: Gregor Schneider [mailto:[EMAIL PROTECTED]
8 snip!
I'm wondering
Gregor,
You can use WHERE x LIKE condition to perform a case-sensitive search
without modifying the structure of the table(s) involved by using the
BINARY keyword.
SELECT * FROM `foo` WHERE `bar` LIKE BINARY 'tesT' will not pull the
record test or Test, but only matches the record tesT.
Todd