Jan 11 2010
Optimizing Case Sensitive Queries in MySQL
Posted by Antone Roundy under TechnologyAdd Your Comments
The other day, I ran into a situation where I needed to do case sensitive queries in MySQL. With a little Googling, I discovered that the keyword “binary” makes that possible, like this:
select foo_field from foo_table where binary foo_key=”foo value”
So I tried it out and it worked, but when querying a table with over a [...]

