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]