Re: PHP Problem or MySQL (Match ... against)?
| From: | Chris Wesley | Date: | Mon, 02 Dec 2002 20:24:03 +0000 |
| Subject: | Re: PHP Problem or MySQL (Match ... against)? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-126755@lists.php.net to get a copy of this message | ||
On Mon, 2 Dec 2002, jtjohnston wrote:
> SELECT id,AU,ST,BT,AT FROM jdaxell.ccl WHERE MATCH
> (TNum,YR,AU,ST,SD,BT,BC,AT,PL,PR,PG,LG,AUS,KW,GEO,AN,RB,CO) AGAINST
> ('"ready maria"' IN BOOLEAN MODE) ORDER
> BY id asc
>
> When I run the same (copied and pasted) SQL in PHP, it is as though
> MySQL is doing a boolean search for
+ready +maria without the
> double
> quotes and finding results in every database. if you search for "ready
> maria" it should only find one entry.
Escape the double quotes. ('\"ready maria\"' IN BOOLEAN ....
g.luck,
~Chris