busboy — 2012-08-28T17:49:36-04:00 — #1
I'm a bit puzzled why the following query returned any results at all. I purposely put a phrase in quotes that I new would not exist in any of the testimonials and yet, somehow, several rows were returned:
select tID, date_format(dateAdded, '%m-%d-%Y') as dateAdded, views, title, MATCH (title,testimony,keywords) AGAINST ('"play baseball" +lemon bruis*') AS score from testimonies where approved = 'Yes' and match (title,testimony,keywords) against ('"play baseball" +lemon bruis*' in boolean mode) order by score desc limit 100
Any thoughts on this one?
r937 — 2012-08-28T19:58:48-04:00 — #2
how many total rows in the table?
busboy — 2012-08-28T20:22:45-04:00 — #3
Approaching 7,000 rows now after several years.
r937 — 2012-08-28T22:28:54-04:00 — #4
sometimes people get weird results from fulltext searches because there are too few rows
can you show the query results for a couple rows that were returned but shouldn't've been?
busboy — 2012-08-29T16:53:27-04:00 — #5
Ok, here is one example that was returned when it shouldn't have as it doesn't contain the exact phrase, "play baseball".
Lemon oil as a deodorant
I've wanted to stay away from the commercial deodorants for long time and couldn't find any natural products that helped. I received my Essential 7 kit and decided to try the lemon oil as a deodorant because in Ecuador people sometimes use lemon juice. Well, the lemon oil has worked perfectly and now that is the only thing I use. Also, one time I forgot to use lemon oil and since I keep Lavender oil at work, I used the Lavender oil and that worked so well!
r937 — 2012-08-29T17:47:25-04:00 — #6
put a plus sign in front of the 'play baseball' and i'll bet this doesn't turn up
busboy — 2012-08-29T18:56:56-04:00 — #7
Oh, that did the trick. Thanks!
mittineague — 2014-09-18T23:06:21-04:00 — #8
This topic is now archived. It is frozen and cannot be changed in any way.