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