SELECT SQL_CALC_FOUND_ROWS *,MATCH (title,jobs.desc) AGAINST ('acca jobs in london') as rele FROM jobs WHERE MATCH (title,jobs.desc) AGAINST ('acca jobs in london') ORDER BY rele DESC LIMIT 0,10