Im having some trouble with my search. this is the code im using: PHP: $searchsql = "SELECT *, MATCH(title) AGAINST($searchkey) AS score FROM moviedb WHERE MATCH(title) AGAINST($searchkey) ORDER BY score DESC"; That's all fine and dandy. it works fine. the problem is when I introduce another column to search. THIS does not work: PHP: $searchsql = "SELECT *, MATCH(title,year) AGAINST($searchkey) AS score FROM moviedb WHERE MATCH(title,year) AGAINST($searchkey) ORDER BY score DESC"; the difference is in the MATCH(title,year). SQL returns this error: #1191 - Can't find FULLTEXT index matching the column list. I can assure you both YEAR and TITLE are fulltext. from phpMyAdmin: Code: title FULLTEXT None Edit Drop title year FULLTEXT None Edit Drop year im so lost. This WAS working previously on an older version of PHP/MySQL... now im using the latest XAMPP distro and its descompuesto. I tried looking through the PHP/MySQL sites to no avail. Ohh.. Im ALSO able to do MATCH(year)... this works fine for searching the year alone. why can I not combine both? I have read many tutorials that have both in there. its so strange.