Re: MYSQL where clause case sensitive?

[Scott R. Godin]

[EMAIL PROTECTED] wrote:

> is MYSQL where clause case sensitive?
> it looks like it is not
> 
> redhat 9
> mysql 3.23.56
> 
> name='Bob' same as name='bob'
> 

For case-sensitivity, use the BINARY cast operator: 

select * from $table WHERE name = BINARY 'Bob';

will only match if it's an exact case match.