> 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 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/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php