Re: Case insensitive records search

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 Case insensitive records search. > > Is

RE: Case insensitive records search

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 inse