For some reason I was under the impression that MySQL searches were case-sensitive unless the "LIKE" syntax was used, but now it appears I was mistaken:

http://www.mysql.com/...ase_sensitivity.html

According to that page, a column needs to be set as "binary" for it to use case-sensitive searching. I understand how to set a column as binary, but I don't really know what it means (other than this narrow issue of case-sensitivity). Does it have any purpose beyond this specific issue?

Thanks in advance.

---

Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund

Oops - guess I should RTFM a little more carefully before posting:

http://www.mysql.com/...ivity_Operators.html

I guess even if a column isn't set as binary you can still do a case sensitive search by slapping the word "BINARY" before the terms you're comparing.

---

Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund