List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 2 2001 2:48am
Subject:Re: Incorrect data returned by REGEXP or RLIKE
View as plain text  
>On Thu, Feb 01, 2001 at 07:09:26PM -0600, Paul DuBois wrote:
>>
>>  Ah, argh.  This happens because REGEXP was changed to be case insensitive
>>  as of MySQL 3.23.4.
>
>Why?
>
>Jeremy
>--
>Jeremy D. Zawodny, <jzawodn@stripped>
>Technical Yahoo - Yahoo Finance
>Desk: (408) 328-7878    Fax: (408) 530-5454
>Cell: (408) 439-9951

Many people wanted it that way.  I forget why.  I guess because you can
force it to be case sensitive now using BINARY, but before there wasn't
a good way to make it case INsensitive if you wanted it to be, at least
not without writing some really ugly patterns.

-- 
Paul DuBois, paul@stripped
Thread
Incorrect data returned by REGEXP or RLIKEDave Cave1 Feb
  • Re: Incorrect data returned by REGEXP or RLIKEGerald L. Clark1 Feb
  • Re: Incorrect data returned by REGEXP or RLIKEPaul DuBois2 Feb
    • Re: Incorrect data returned by REGEXP or RLIKEJeremy D. Zawodny2 Feb
      • Re: Incorrect data returned by REGEXP or RLIKEPaul DuBois2 Feb