title: SQL search result ranking
body: <p>I have a table call objects which there are the columns:</p>
  
  <pre><code>object_id, 
  name_english(vchar), 
  name_japanese(vchar), 
  name_french(vchar), 
  object_description 
  </code></pre>
  
  <p>for each object. </p>
  
  <p>When a user perform a search, they may enter either english, japanese or french... and my sql statement is:</p>
  
  <pre><code>SELECT  
   o.object_id,  
   o.name_english,
   o.name_japanese,  
   o.name_french,  
   o.object_description  
  FROM 
   objects AS o
  WHERE 
   o.name_english LIKE CONCAT('%',:search,'%') OR 
   o.name_japanese LIKE CONCAT('%',:search,'%') OR 
   o.name_french LIKE CONCAT('%',:search,'%')    
  ORDER BY 
   o.name_english, o.name_japanese, o.name_french ASC
  </code></pre>
  
  <p>And some of the entries are like: </p>
  
  <pre><code>Tin spoon,  
  Tin Foil,  
  Doctor Martin Shoes,  
  Martini glass,  
  Cutting board,  
  Ting Soda.   
  </code></pre>
  
  <p>So, when the user search the word "Tin" it will return all results of these, but instead I just want to return the results which specific include the term "Tin" or displaying the result and rank them by relevance order. How can I achieve that?</p>
  
  <p>Thanks.</p>