mysql case insensitive where code example

Example: where case insensitive mysql

SELECT * FROM `table` WHERE LOWER(`Value`) = LOWER("THE_VALUE")