Hi all,

Code:

select emp_name from employee where emp_name="Random";

In MySql, the above query is returns the results as,

Code:

Random
random
RANDOM
RaNdOm

4 Rows selected

But I want to retrieve the result that contain only the name i gave it in 'where' clause. i.e i want to perform 'case-sensitive' comparison.
How to do?

__________________
Regards,
VELHARI
I am not totally useless. I can be used for a bad example

Hi Vel,

We have discussed this problem in this forum already, please do refer this

http://www.discussweb.com/database-s...rch-mysql.html

__________________
Keep smiling...