full text search accuracy
Posted 23 August 2006 - 12:50 AM
$query = "SELECT news.newsID, news.name AS news, news.abstract, news.fulltext, date.name AS date, author.name AS author,
MATCH(news.name, news.abstract, news.fulltext)
AGAINST ('$searchstring') AS score FROM news, date, author
WHERE MATCH(news.name, news.abstract, news.fulltext)
AND date.dateID = news.dateID AND author.authorID = news.authorID
ORDER BY score DESC";
but even if i know a certain word is in the entry im searching, often i wont get any articles coming up as results.
Is there anything that might cause this like the 50% threshhold? or blocked words?
for instance if I search 'database' i get a result, yet right next to it is the word 'available' but if i type that in there are no results
Any idea why?
ALSO! if i want to make a certain field more sensitive would I have to make it its own table.. like a title table? or can i just choose to search that field? i know i have to have the same fields in my select as are in my index table so i cant just not include a field as far as i know
Posted 23 August 2006 - 01:58 AM
Posted 23 August 2006 - 03:55 AM
okay.. well that just means that the inaccuracy is out of my control which is good news... take that users!
Posted 23 August 2006 - 04:13 AM
also i eliminated the text area and just left the title, abstract,... 4 fields in total... it officially doesnt work.. but there is no error
here is the query:
$sql = "SELECT research.researchID, research.name AS research, research.coresearch, research.affiliation, research.abstract,
research.fulltext, date.name AS date, author.name AS author,
MATCH(research.name, research.abstract, research.coresearch, research.affiliation)
AGAINST ('$searchstring') AS score FROM research, date, author
WHERE MATCH(research.name, research.abstract, research.coresearch, research.affiliation)
AND date.dateID = research.dateID AND author.authorID = research.authorID
ORDER BY score DESC";
this is what its searching:
research name: More crazy research
abstract: The plague is bad
it has 9 words to search and if i type in any of them it wont find the article.. are all the words occuring too often?
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users