case sensitive?

[mshen]

I just develop a PHP and MySQL application.but the probleem is SQL statemant is case insensitive.

using
select from table1 where term='AAAA'
or
select from table1 where term='aaaa'

get the same records.but I need to do case sensitive operation.

Please let me know how to do it with PHP or MySQL.

Thanks

[thessoro]

you can try:

Select * from table1 where term=binary'aaa'