At 05:10 PM 12/9/2002 -0500, Beauford.2003 wrote:
>I mentioned in my previous email that I am using PHP, and I have also tried
>putting quotes around $var (many different ways) with no better results.
>REGEXP just gives a syntax error when I do this.
Below is an example of using PHP and MySQL wit
Hello.
On Mon 2002-12-09 at 09:22:09 -0500, [EMAIL PROTECTED] wrote:
> I am using PHP on my website, but this is certainly a MySQL question.
>
> > That shouldn't matter, because the real value $var is inserted before
> > the query is send to the MySQL server, where REGEXP of the query is
> > eval
On Mon, 2002-12-09 at 16:10, Beauford.2003 wrote:
> Andy,
>
> I mentioned in my previous email that I am using PHP, and I have also tried
> putting quotes around $var (many different ways) with no better results.
> REGEXP just gives a syntax error when I do this.
I'm sorry, I did miss the where y
> - Original Message -
> From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
> To: "Beauford.2003" <[EMAIL PROTECTED]>
> Cc: "Robert Citek" <[EMAIL PROTECTED]>; "MySQL List"
> <[EMAIL PROTECTED]>
> Sent: Monday, Dec
> This is most definitely a quoting issue with your PHP string. If it is
> quoted correctly, the MySQL server will never see the string $var
> appearing after the keyword REGEXP, so if $ has meaning to a regular
> expression wouldn't matter (unless the value of $var contained a $).
> I've used RE
ED]>
Cc: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 3:08 PM
Subject: Re: Select * From table where name Like 'help'; Help
> You still have not mentioned what language you are using to interface
> with MySQL. If you are using PHP or Perl, th
Beauford
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: "Beauford.2003" <[EMAIL PROTECTED]>
Sent: Monday, December 09, 2002 9:31 AM
Subject: Re: Select * From table where name Like 'help'; Help
> No it doesn
at http://www.mysql.com/doc/en/Regexp.html, but it does
not cover this.
- Original Message -
From: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
To: "Beauford.2003" <[EMAIL PROTECTED]>
Cc: "Robert Citek" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL
Hello.
On Mon 2002-12-09 at 01:00:33 -0500, [EMAIL PROTECTED] wrote:
> I am doing this search from a website,
What does that mean? Which scripting language do you use? PHP? This is
more a question for your "website" environment than about MySQL.
> and from what I can tell there is no way to use
t; <[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:
>
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#Re
Hi,
A "dirty" solution would be to search :
field LIKE '% one %' or field LIKE 'one %' or field LIKE '% one' or
field='one';
Regards,
Jocelyn
- Original Message -
From: "Beauford.2003" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 12:50 AM
12 matches
Mail list logo
