Help with FULLLTEXT syntax
I believe the proper syntax for the query I'm after would be:
However, using that query I get an error of
SELECT * FROM `table` WHERE MATCH (title,description) AGAINST('_search_term_')
#1191 - Can't find FULLTEXT index matching the column list
When I use this query though, all is well:
It's my understanding that the first one should work. Any help on the matter is appreciated.
SELECT * FROM `table` WHERE MATCH (title) AGAINST('templates') OR MATCH (description) AGAINST('templates')