making a search case SENSITIVE

[sfullman]

Hi there,

I have a char field that is not binary. I want to search for "And" but miss instances of "and" (LCASE). How would I do this? Do I need to cast the data as binary or something? Usually I WANT to find everything, but in this case I only want matching case.

Sam

[tsinka]

Hi,

you can do something like

SELECT fieldlist FROM atable WHERE STRCMP(thefield, 'And') = 1

Thomas

[ahundiak]

SELECT this FROM that WHERE BINARY foo = 'Bar';
http://dev.mysql.com/doc/mysql/en/Cast_Functions.html