MySQL Queries

[Niclov]

Hi,
I'm relatively new to using MySQL and am having some difficulties formulating queries. I'm trying to retrieve exact matches from my table, but the search seems to be case insensitive, and returns all entries containing the same letters, regardless of the words being upper-case or lower-case. Is there a way to correct this?

 

[rycamor]

Browse the online documentation for the differences between column types, and column options:

http://www.mysql.com/doc/C/o/Column_types.html

You will see that for CHAR, VARCHAR, TEXT, and BLOB datatypes, there is always a way to force sorts and comparisons to be case-sensitive.

For example, TEXT and BLOB are identical, except that TEXT columns are case-insensitive while BLOB columns are case-sensitive.