RE: Case sensitive in selecting records

2001-12-27 Thread Carsten H. Pedersen
-sensitive in selecting records... SELECT BINARY ... / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com

Case sensitive in selecting records

2001-12-26 Thread SankaraNarayanan Mahadevan
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 records... how to make it case-sensitive