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