PDA

View Full Version : match..against in mysql


sahajin
6-16-04, 02:21 PM
lets say I have a variable like so

$var = "http://google.yahoo.";

and if I used

$Q = "select stats_referrer, stats_page_visited, MATCH (stats_referrer) AGAINST ('$sear') AS score from $_STATS_stats where MATCH (stats_referrer) AGAINST ('$sear') ";

how can I use " in the against so it will get exaclty what is typed? even though I didn't type it.

as it stands now, it will return yahoo and google rows. not the one I wanted.

so I have to change the " into &quote;

I tired the quote thing, I tired changing the period to the ascii format and no luck.

any ideas?