Paul, At 16:56 2001-11-25 -0600, Paul DuBois wrote: >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
But the original report (which I quoted, and still quote) was that the latter (the intended effect) did not work as it returned also "brain". Your solution is apparently no solution to this problem. So the question remains what the solution (or the cause of the problem!) is. -- (database,sql,query,table) GRRR!!! 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
