While building a site around MySQL, there may come a time when you want to make a query that is case sensitive. You get down to coding, only to realize that no matter how hard you try, everything still matches!
The reason you can't do a case sensitive query is because most databases will automatically set a case insensitive collation for all of your tables. The only way you can fix this is to either change the table collation (which makes everything case sensitive), or you can cast your query like this:
SELECT * FROM [tablename] WHERE [fieldname] = BINARY 'Hello World'
This will match 'Hello World' but will not match 'hello world'.
If you're not feeling up to the challenge of changing the query on your own (or you're feeling lazy) then if you have phpMyAdmin, you can do the following: