List:General Discussion« Previous MessageNext Message »
From:Beauford.2003 Date:December 9 2002 6:00am
Subject:Re: Select * From table where name Like 'help'; Help
View as plain text  
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
>
>


Thread
Select * From table where name Like 'help'; HelpBeauford.20039 Dec
  • Re: Select * From table where name Like 'help'; HelpJocelyn Fournier9 Dec
  • Re: Select * From table where name Like 'help'; HelpRobert Citek9 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.20039 Dec
      • Re: Select * From table where name Like 'help'; HelpBenjamin Pflugmann9 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.20039 Dec
      • ADO Bulk InsertsMichael She10 Dec
        • RE: ADO Bulk InsertsFernando Grijalba10 Dec
          • RE: ADO Bulk InsertsMichael She10 Dec
            • RE: ADO Bulk InsertsFernando Grijalba10 Dec
              • RE: ADO Bulk InsertsMichael She10 Dec
                • RE: ADO Bulk InsertsFernando Grijalba10 Dec
                  • RE: ADO Bulk InsertsMichael She10 Dec
                    • RE: ADO Bulk InsertsPaul DuBois11 Dec
                      • RE: ADO Bulk InsertsMichael She11 Dec
                        • RE: ADO Bulk Insertsed11 Dec
                        • RE: ADO Bulk InsertsPaul DuBois11 Dec
      • Re: OT Select * From table where name Like 'help'; HelpMichael T. Babcock10 Dec
      • Re: Select * From table where name Like 'help'; HelpAndy Bakun10 Dec
      • Re: Select * From table where name Like 'help'; HelpBenjamin Pflugmann10 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.200310 Dec
      • Re: Select * From table where name Like 'help'; HelpAndy Bakun10 Dec
      • Re: Select * From table where name Like 'help'; HelpRobert Citek10 Dec
    • Re: Select * From table where name Like 'help'; HelpBeauford.200310 Dec
  • Re: Select * From table where name Like 'help'; HelpBeauford.20039 Dec
RE: ADO Bulk InsertsAlan R Anderson11 Dec
  • RE: ADO Bulk InsertsMichael She11 Dec