SELECT id, sitename, description, date
MATCH(sitename, keyword1, keyword2, keyword3, keyword4, keyword5, keyword6, description) AGAINST ('criteria') AS totaltimes
FROM sites
WHERE MATCH(sitename, keyword1, keyword2, keyword3, keyword4, keyword5, keyword6, description) AGAINST ('criteria')
ORDER BY totaltimes DESC


*ERROR I GET*
 MySQL Error#: 1064

You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'MATCH(sitename, keyword1, keyword2, keyword3, keyword4, keyword