Help with FULLLTEXT syntax

[Greg-J]

I believe the proper syntax for the query I'm after would be:

SELECT * FROM `table` WHERE MATCH (title,description) AGAINST('_search_term_')

However, using that query I get an error of
#1191 - Can't find FULLTEXT index matching the column list

When I use this query though, all is well:

SELECT * FROM `table` WHERE MATCH (title) AGAINST('templates') OR MATCH (description) AGAINST('templates')

It's my understanding that the first one should work. Any help on the matter is appreciated.

[longneck]

to use fulltext indexing, you MUST have an index that EXACTLY matches what you have in your match() request.

alter table `table` add fulltext index (title, description)

[Greg-J]

I had added the index to each individual column, but didn't realize I needed to do so for both together.

Thank you very much.