[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.