svincent2000
10-11-2002, 12:05 PM
I am trying to get some decent results from using:
SELECT * FROM $Articles WHERE MATCH (article_body) AGAINST ('$searchstring')
$searchstring is a PHP variable from a FORM
I think that there is a default 50% threshold thing which stops all return values if there is more than 50% read.
Anyone got this working satisfactorily? I was think of setting up a new table field called KEYWORDS, and running the MATCH against that... what do you think? Thanks
Simon
SELECT * FROM $Articles WHERE MATCH (article_body) AGAINST ('$searchstring')
$searchstring is a PHP variable from a FORM
I think that there is a default 50% threshold thing which stops all return values if there is more than 50% read.
Anyone got this working satisfactorily? I was think of setting up a new table field called KEYWORDS, and running the MATCH against that... what do you think? Thanks
Simon