I have just started to use the BOOLEAN mode in MySQL, however how do I order by relevance using it?
I am using the following sql query, but it throws unknown column "relevance".
count(applications.id) as applications,
count(featured_jobs.id) as featured from jobs
inner join companies on companies.id = jobs.company_id
inner join industries on industries.id = jobs.industry
inner join job_types on job_types.id = jobs.job_type
left outer join applications on applications.job_id = jobs.id
left outer join featured_jobs on featured_jobs.job_id = jobs.id
where jobs.status='on' and MATCH(jobs.job_title,jobs.job_description) AGAINST('+pilot' IN BOOLEAN MODE) AS relevance
group by jobs.id order by relevance