List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:November 25 2001 10:56pm
Subject:Re: Re: String Comparision
View as plain text  

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 and select binary dbname from users where
>>>dbname="brain" also returns both records.
>>SELECT dbname FROM users WHERE BINARY dbname = "brain"
>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

WHERE dbname = "brain"     returns only "brain" records
WHERE dbname = "Brain"     returns only "Brain" records

>Marjolein Katsma      webmaster@stripped
>Java Woman -
Re: Re: String ComparisionPaul DuBois25 Nov
  • Re: Re: String ComparisionMarjolein Katsma26 Nov
    • Re: Re: String ComparisionMichael Stassen27 Nov