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 it's possible and how?
>
> Thanks a lot!
>
> Andis
There is no case insensitive type in MySQL as far as I know but you should be able to
do it with regular expression
lokk for them in the manual.
Lars
---------------------------------------------------------------------
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
