Andis Grasis wrote:
> 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 Ca
+
|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
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
