Boolean search returning results when it should not
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?