Sorry for being kind of off-topic.
I am using the fulltext search feature on a database containing documentation on books. I am getting some odd results though. An example is this: query->('brave new world+summary').
The result with the largest score doesn't even deal with the book 'A Brave New World'. Since fulltext seperates all the 'words', and does a search for them by independently, the #1 result simply has 'brave', 'world' and 'summary' the most times (..right?).
Is there a way at all, to incorporate quotes? Anything in the quotes is acknowledged by the parser as one 'word'? so query->('"brave new world"+summary') would definetly return better results. Any ideas?
I am using the fulltext search feature on a database containing documentation on books. I am getting some odd results though. An example is this: query->('brave new world+summary').
The result with the largest score doesn't even deal with the book 'A Brave New World'. Since fulltext seperates all the 'words', and does a search for them by independently, the #1 result simply has 'brave', 'world' and 'summary' the most times (..right?).
Is there a way at all, to incorporate quotes? Anything in the quotes is acknowledged by the parser as one 'word'? so query->('"brave new world"+summary') would definetly return better results. Any ideas?