Where binary in SQL
mysql
Solution
`BINARY` is a built-in keyword that after your `WHERE` clause that forces a comparison for an exact case-sensitive match.
As a side note, you can also make columns case-sensitive by adding the `BINARY` keyword when you create your table.
Problem
I have an SQL statement: `SELECT * FROM customers WHERE BINARY login='xxx' AND password='yyyy'` There are no blob/binary fields in the table, do I need the BINARY after the WHERE what else does it do?