When I add FULLTEXT indexes to my table (I add an separate index for two of columns) and try to use these using the
MATCH (name_index_column_1) AGAINST ('searchword')
command, my query works. However when trying to search in both indexes the query doesn't work. I use the following statement:
MATCH (name_index_column_1,name_index_column_2) AGAINST ('searchword').
Although i want to be able to search the two columns independently, I also made a single index out of the two columns to see if that would work: it did not.
I could really use some help on this one.
