Re: Lower case queries

[Nick Roper]

Hi John,

Comparisons between literal strings are not case-sensitive.

If you want to only find records that contain lower-case instances of 'widgets', then use:

AND BINARY type LIKE '%widgets%'

or

AND type LIKE BINARY '%widgets%'

This will convert one of the strings to a binary representation, and forces a binary (case-sensitve) comparison.

You don't need to use the BINARY keyword for both. If either side of the comparison is binary, then both strings will be compared using their binary representation.

Hope this helps,

Nick

--
Nick Roper