Untitled

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