Hi Guys..

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".

PHP Code:
select 
    jobs
.job_title
    
companies.company_name
    
companies.company_url
    
companies.logo_thumbnail
    
jobs.job_url
    
jobs.job_salary
    
jobs.job_ote
    
jobs.job_perks
    
jobs.job_description
    
jobs.location
    
jobs.date_posted
    
industries.industry
    
job_types.job_type
    
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_descriptionAGAINST('+pilot' IN BOOLEAN MODE) AS relevance 
group by jobs
.id order by relevance