in MYsql how to check string value without case code example

Example: select binary case sensitove

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