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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php