mysql> SELECT 'a' LIKE 'A';
+--------------+
| 'a' LIKE 'A' |
+--------------+
| 1 |
+--------------+
1 row in set (0.00 sec)
mysql> SELECT 'a' LIKE 'b';
+--------------+
| 'a' LIKE 'b' |
+--------------+
| 0 |
+--------------+
1 row in set (0.00 sec)
It's already case insensitive.
> Hi!
>
> I have such SQL :
>
> select CompanyName from Company where CompanyName like '%car%'
>
> Really I need in query result all of companys, which contains
> symbols CAR in any case (car, Car,CAr, CAR, e.t.c).
> I think that I need Case insensitive records search.
>
> Is it's possible and how?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
