subject:"case insensitive regexp"

Re: case insensitive regexp

2001-05-05 Thread Joseph Bueno

Tom Svensson wrote: > > Hi! > > I'm using version 3.23.37 of MySQL (for Windows). Why does REGEXP > seems to be case insensitive? > Queries like > SELECT "tom" REGEXP "tOm"; > returns 1 Why? And how can I solve it (to return 0)? > > Regards, > Tom S. > > ---

case insensitive regexp

2001-05-05 Thread Tom Svensson

Hi! I'm using version 3.23.37 of MySQL (for Windows). Why does REGEXP seems to be case insensitive? Queries like SELECT "tom" REGEXP "tOm"; returns 1 Why? And how can I solve it (to return 0)? Regards, Tom S. - Before pos