title: Mysql fulltext search relevance across multiple tables
body: <p>I have been tasked with creating a site wide search feature. The search needs to look at articles, events and page content</p>
  
  <p>I've used MATCH()/AGAINST() in MySQL before and know how to get the relevance of a result but as far as I know the relevance is unique to the search (contents, number of rows etc) the relevance of results from the articles table wont match the relevance of results from the events table.</p>
  
  <p>Is there anyway to unify the relevance so that results from all three tables have a comparable relevance?</p>