2 ms·
If I look for one single word and that single word is the answer, shouldn't that be the very first result? I mean that's a 100% match right there...
by soco 5y ago
If I look for one single word and that single word is the answer, shouldn't that be the very first result? I mean that's a 100% match right there...
- rahimnathwani 5y agoIf the dataset were perfect, maybe. But, if a book with a single-word title has only few comments, it's plausible that most/all of those comments are false matches. In the case of the book I searched 'Who', showing it in 4th position seemed about right.
- tracyhenry 5y agoy the search can definitely be improved (e.g. to include author). Right now it's SELECT * FROM books WHERE name LIKE '%{search_string}%'