Syntax:
BINARY expr

The BINARY operator converts the expression to a binary string. A
common use for BINARY is to force a character string comparison to be
done byte by byte rather than character by character, in effect
becoming case sensitive. The BINARY operator also causes trailing
spaces in comparisons to be significant.

URL: http://dev.mysql.com/doc/refman/5.7/en/cast-functions.html

