mysql query problems

[prismphpbuilder]

I am using PHP/mysql combination. i have noticed that when i used the mysql query like "select * from tblname where field1='something' and field2='something' order by autoid" returned me the case insensetive result. This should not be the case when i am using '=' in query.
Can anybody help me out?

thanks

[Anon]

String comparisons in mysql are normally case-insensitive.

You could manipulate the data using your server-side scripting language and saved it as a variable. Then make the comparison in your select statement using that variable.

Otherwise, if you know the result you want to match the input to, you could use the REGEXP function. eg.

select * from pet where name
REGEXP "[w]";

This would find the names that would contain w in lowercase only.

Hope this helps...

[tasistro]

It doesn't perform a binary comparison, from the mysql manuals

1)

MySQL performs comparisons using the following rules:
If one or both arguments are NULL, the result of the comparison is NULL, except for the <=> operator.
If both arguments in a comparison operation are strings, they are compared as strings.
If both arguments are integers, they are compared as integers.
Hexadecimal values are treated as binary strings if not compared to a number.

2)

mysql> select 'abc' LIKE 'ABC';
-> 1
mysql> SELECT 'abc' LIKE BINARY 'ABC';
-> 0

Saludos
Gerardo