mysql how to fetch data case not sensitive code example

Example: select binary case sensitove

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