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]
