Forcing case sensitivity in queries

[Yannick Warnier]

Hi,

When I execute a query in MySQL client, it seems like I cannot get the
case-sensitivity to be activated.

If I ask:
SELECT * FROM mytable WHERE field = 'd';

I get all records containing 'd' or 'D'.

How do I enable case-sensitivity?

Thanks,

Yannick


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Forcing case sensitivity in queries

[Michael Stassen]

You need BINARY http://dev.mysql.com/doc/mysql/en/Cast_Functions.html.
  SELECT * FROM mytable WHERE BINARY field = 'd';
Michael
Yannick Warnier wrote:
Hi,
When I execute a query in MySQL client, it seems like I cannot get the
case-sensitivity to be activated.
If I ask:
SELECT * FROM mytable WHERE field = 'd';
I get all records containing 'd' or 'D'.
How do I enable case-sensitivity?
Thanks,
Yannick

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Forcing case sensitivity in queries

[Yannick Warnier]

Le dim 05/09/2004 à 00:14, Yannick Warnier a écrit :
 Hi,
 
 When I execute a query in MySQL client, it seems like I cannot get the
 case-sensitivity to be activated.
 
 If I ask:
 SELECT * FROM mytable WHERE field = 'd';
 
 I get all records containing 'd' or 'D'.
 
 How do I enable case-sensitivity?

OK sorry, I found that using 'binary' solves the problem.
SELECT * FROM mytable WHERE field = binary 'd';


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]