Also of note is that you can use the BINARY keyword in your query without using a BINARY colunn. For example:

SELECT 'abc' LIKE BINARY 'ABC';
[download]