busboy — 2012-08-31T12:33:24-04:00 — #1
The first query produces many rows. The second query doesn't produce any. If I change the keyword to lemon instead of believe, then both queries produce results. Any ideas on this one?
select * from searches where keyword = 'believe' order by sID;
select * from searches where MATCH(keyword) AGAINST('believe');
cpradio — 2012-08-31T12:48:18-04:00 — #2
Does keyword have FULLTEXT enabled?
r937 — 2012-08-31T13:32:36-04:00 — #3
perhaps 'believe' occurs in more than half the rows
remember, fulltext searching is supposed to work best on large datasets with sparse matches, and in particular, it's optimized for more complex searches, e.g. '+apple +(>turnover <strudel)'
mittineague — 2014-09-18T23:02:00-04:00 — #4
This topic is now archived. It is frozen and cannot be changed in any way.