Searching on "believe" gets inconsistent results

Databases
1

I’m a bit baffled why the following query produces zero results:

select
	* 
from 
	testimonials 
where 
	match (title,body,keywords) AGAINST ('believe');

While the following query, using the exact same keyword, believe, produces over 800 results. The testimonials table has about 10,000 rows, so 800 rows should be considered a sparse match when it comes to full text searching, right?

select
	*
from 
	testimonials
where
	title like '%believe%' 
	or body like '%believe%' 
	or keywords like '%believe%';

This is the only keyword search that has ever produced results like this. Using other common searches, like lavender, produce the same results in both queries. Lavender also produces more results, 2,245 to be exact, compared to the more “sparse” word of believe.

Anyone have any ideas why this is the case?

Thank you.

2

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.