I added a new column called 'title', which is basically a duplicate of another column called summary. I then edited my index to include this new column, but now the following query errors out. What did I do wrong?
Query: SELECT tID, date_format(dateAdded, '%m-%d-%Y') as dateAdded, viewed, title, MATCH (title,testimony,keywords) AGAINST ('lemon') AS score FROM testimonies WHERE MATCH (title,testimony,keywords) AGAINST ('lemon') and approved = 'Yes' order by score desc limit 50
Error: mysql_errno() Can't find FULLTEXT index matching the column list