Case sensitivity

[poring]

I would like to make the following mysql query:
SELECT count(*) FROM table WHERE bleh = '$blah'
where the = would be case sensitive.

How would that be done? Thanks.

[Lars_Berg]

SELECT count(*) FROM table WHERE cast(bleh as binary) = '$blah' 

[killerbishop]

Your table definition can also force the field "bleh" to be binary, like:

CREATE TABLE example(

bleh    VARCHAR(255) BINARY

);

If it isn't a VARCHAR, but a TEXT, make this:

CREATE TABLE example (

bleh BLOB

);