Re: Newbie: case insensitive login

[Felix Geerinckx]

Tara Erkelens wrote:

> Ive been to forums where ppl talked about LIKE and ILIKE.
> i still didnt figure out how to use ILIKE (which is case insensitive comparisation from what ive
> read), so id like to learn more here.

I have never heard of ILIKE in MySQL.

But in http://dev.mysql.com/doc/mysql/en/string-comparison-functions.html, one can read:

The following two statements illustrate that string comparisons are not case sensitive unless one of the
operands is a binary string:

mysql> SELECT 'abc' LIKE 'ABC'; -> 1
mysql> SELECT 'abc' LIKE BINARY 'ABC';-> 0

--
felix
Please use BBCode to format your messages in this forum.