WHERE do MySQL case-insensitive

SELECT * FROM pozycje Where UCASE(poz_nazwa) Like UCASE("%greg%")

which effectively makes string comparisons case insensitive despite the
Binary character set chosen.


http://bytes.com/topic/mysql/answers/592865-case-insensitive-search-mysql