View Single Post
  #9 (permalink)  
Old 07-14-2004, 10:55 PM
HardCoded HardCoded is offline
WebProWorld Veteran
 

Join Date: Apr 2004
Posts: 453
HardCoded RepRank 0
Default

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
Reply With Quote