List:General Discussion« Previous MessageNext Message »
From:Fred Lindberg Date:April 16 1999 6:22pm
Subject:Re: Case Sensitive Searching
View as plain text  
On Fri, 16 Apr 1999 11:16:43 -0700, Kevin P. O'Brien wrote:

>User will enter query string in all lower case:  Output is case-insensitive search
>User enters at least one uppercase character in query: Output is case-sensitive
> search.

1. Two fields with same string, one (b) binary one not (a): ... WHERE
a='key' OR b='key'.

2. char field. WHERE a='key', then if 'key' contains at least one upper
case char, do an exact match of the result in your application, and
present only matches. Requires a little code, but saves space. Fast
unless you have very strange data with lots of lines differing only in
the case.

3. ?


-Sincerely, Fred

(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)



Thread
Case Sensitive SearchingKevin P. O'Brien16 Apr
  • Log fileChai-Hup Chen16 Apr
    • mysql performance way down with phpShalendra Majmundar17 Apr
    • Re: mysql performance way down with phpDaniel Koch17 Apr
      • Re: mysql performance way down with php(Graeme B. Davis)17 Apr
    • Log fileMichael Widenius17 Apr
Re: Case Sensitive SearchingFred Lindberg16 Apr