I am doing this search from a website, and from what I can tell there is no way to use a variable (i.e. $var) with REGEXP as the $ sign has a special meaning to REGEXP. Any other suggestions, or would you know a way around this.
TIA ----- Original Message ----- From: "Robert Citek" <[EMAIL PROTECTED]> To: "Beauford.2003" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]> Sent: Sunday, December 08, 2002 8:16 PM Subject: Re: Select * From table where name Like 'help'; Help > > Try the REGEXP modifier. For example: > > mysql> select "Another One" regexp "[[:<:]]One[[:>:]]" ; > mysql> select "Fashioned" regexp "[[:<:]]One[[:>:]]" ; > > The format differs from that used in sed, grep, awk, perl, python, etc. > > http://www.mysql.com/documentation/mysql/bychapter/manual_Regexp.html#Regexp > > Regards, > - Robert > > ----- > > At 07:50 PM 12/9/2002 -0500, Beauford.2003 wrote: > > If I search for the word - One - I want to see: > > Another One > > But not: > > Fashioned > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php