Is it possible to create a full-text index on a longtext column type.
I have a script that generates the following sql for example..
SELECT id, file_name, title, date_added,data, match (title,data) against (' farming ') as relevance FROM resource WHERE match (title,data) against ('farming')>0 HAVING relevance>0 ORDER BY relevance DESC
When I execute this query from the command prompt I get
ERROR 1191: Can't find FULLTEXT index matching the column list
even though...
SHOW INDEX FROM resource would indicate that columns (title,data) are both FULLTEXT
Any ideas??