in Masql how to check string value case insensitve code example

Example: select binary case sensitove

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