What is this error message trying to tell me?
select tID, date_format(date, '%m-%d-%Y') as showDate, viewed, summary, MATCH (summary)
AGAINST ('lemon') AS score from testimonies where approved = 'Yes' and match (summary) against
('lemon' in boolean mode) order by score desc limit 50;
Error Code: 1191. Can't find FULLTEXT index matching the column list
it's trying to tell you that you forgot to declare a fulltext index on the column(s) that you are trying to search in
ALTER TABLE testimonies
This topic is now archived. It is frozen and cannot be changed in any way.