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: https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html

