title: Can I prioritize the same word differently in different rows of a FULLTEXT column?
body: <p>I have a site search that works by extracting words from several fields of my <code>articles</code> table (<code>name</code>, <code>body</code>, <code>author</code>, <code>category</code>), and putting all of them in a separate search table with a single FULLTEXT column.</p>
  
  <p>I want to improve the accuracy of the search so that words extracted from the <code>name</code> field have a higher relevance than the same words extracted from the <code>body</code> field of the <code>articles</code> table.</p>
  
  <p>In other words, if article 1's <code>name</code> field contained "Foo" once and article 2's <code>body</code> field contained "Foo" twice, article 1 would still be more relevant.</p>
  
  <p>Is there a way to do this? I'm not referring to boolean searching, I want to attach relevance to the actual column data, not the search string.</p>