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’);