List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:August 5 1999 11:27am
Subject:Re: LIKE operator
View as plain text  
Thimble Smith wrote:
> 
> At 19:49, 19990804, toxalot@stripped wrote:
> >I read up on it and there doesn't seem to be a way to ignore case like you
> >can with perl.  It explains how to match the lower or uper case version.
> >Does that mean that I will have to manually alter the keyword that the user
> >enters into my text box to be any mix of upper and lower case?  Or is there
> >a way around this?
> 
> If case isn't going to be important, I'd recommend storing the text in
> the database all in lower case, and converting the words the user enters
> to lower case before doing the search.  Or, you can use something like:
> 
>     SELECT id FROM table_name WHERE LCASE(field) REGEXP "[[:<:]]word[[:>:]]"
> 
> Tim

Hi Tim

If you use different languages, you should store them in UPPERCASE.
In some languages there are characters, which have two different lowercase representations
but only one uppercase.

Tschau
Christian

Thread
LIKE operatortoxalot4 Aug
  • Re: LIKE operatorThimble Smith4 Aug
    • Re: LIKE operatortoxalot4 Aug
RE: LIKE operatoradhir4 Aug
  • Re: LIKE operatorThimble Smith4 Aug
RE: LIKE operatoradhir4 Aug
  • RE: LIKE operatortoxalot5 Aug
    • Re: LIKE operatorThimble Smith5 Aug
Re: LIKE operatorChristian Mack5 Aug
RE: LIKE operatoradhir5 Aug