title: Specify rank in ranked search query PHP, MySQL
body: <p>I've got a search query witch sorts the results based on how many times the term is used in an article. For example 1 time in the title and 1 time in the content. This one will end higher up in the list than a article with te term only in it's content area.
  But I want a little extra, is it possible to add multipliers, for example when the term is used in the title then it counts for 2 instead of one. Look at the code below:</p>
  
  <pre><code>&lt;?PHP
  
  //SET THE SEARCH TERM
  $term = "Search Term";
  
  $sql = "SELECT *, MATCH(subject, message,reference,textbody) AGAINST('". $term ."') as score FROM pages WHERE MATCH (subject, message,reference,textbody) AGAINST('". $term ."') ORDER BY score DESC";
  $query = mysql_query($sql);
  
  //BUILD A LIST OF THE RESULTS
  while($result = mysql_fetch_assoc($query)) {
     // your stuff for showing result
  }
  ?&gt;
  </code></pre>
  
  <p>Could you please help me out?</p>