RE: Case sensitive in selecting records

gt; MySQL is case insensitive in selecting records... > how to make it case-sensitive in selecting records... SELECT BINARY ... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --

Case sensitive in selecting records

Hi, I have a situation as follows: There is a table that stores the user name. One user name is 'David' and another is 'david' I want to select only the user with the name 'david'(all small and not 'David') MySQL is case insensitive in selecting rec