Even simpler to use the IF() function:
Code:
select *,
IF(`Course_Title` like \"%$trimmed%\",0,1) AS in_title
from pitman_courses
where `Course_Title` like \"%$trimmed%\"
OR `Target_Audience` like \"%$trimmed%\"
OR `Prerequisites` like \"%$trimmed%\"
OR `Aims_and_objectives` like \"%$trimmed%\"
OR `Course_Content` like \"%$trimmed%\"
order by in_title, Course_Title