MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Benjamin Pflugmann Date:June 25 1999 1:46am
Subject:Re: Regexps
View as plain text  
Hi.

AFAIK, regular expressions do not offer any way to specify case
insensitivity. You can use LOWERCASE() on both parameters, though
(which is "almost" the same as if MySQL would support it with a keyword).

Bye,

	Philemon.

On Thu, Jun 24, 1999 at 09:50:50AM -0700, freek@stripped wrote:
> Does anyone know how to force case insensitivity for REGEXP? I have to
> search for keywords with different or mixed cases, and changing
> everything to lower case is not a good option. I am hoping for something
> along the lines of perl's /i option.
> 
> Thank you kindly
> 
> --
> Life is out to get me....
> ERTW!
> 
> 
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread5814@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.

Attachment: [application/pgp-signature]
Thread
RegexpsfrEEk24 Jun
  • Re: RegexpsBenjamin Pflugmann25 Jun