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