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