database,sql,query,table At 7:40 PM +0100 11/25/01, Marjolein Katsma wrote: >At 12:19 2001-11-25 -0600, Paul DuBois wrote: >>>select * from users where dbname= "Brain" returns both "brain" and "Brain". >>> >>>I read section 6.3.2.2 and select binary dbname from users where >>>dbname="brain" also returns both records. >> >>SELECT dbname FROM users WHERE BINARY dbname = "brain" >> >>perhaps? > >How would that locate records with "Brain"? Doesn't sound like a >solution to me...
It wouldn't locate such records. BINARY makes the comparison case sensitive. WHERE dbname = "brain" returns only "brain" records WHERE dbname = "Brain" returns only "Brain" records > >Marjolein Katsma [EMAIL PROTECTED] >Java Woman - http://javawoman.com/ --------------------------------------------------------------------- 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
