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 webmaster@stripped
>Java Woman - http://javawoman.com/
