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" <rwcitek@stripped>
To: "Beauford.2003" <beauford.2003@stripped>
Cc: "MySQL List" <mysql@stripped>
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 <mysql-thread126964@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-beauford.2003=rogers.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
