where is case sensitive or insensitive in mysql code example

Example: select binary case sensitove

SELECT *  FROM `table` WHERE BINARY `column` = 'value'