How would you make a case-insensitive query in MySQL? code example

Example: where case insensitive mysql

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