title: MySQL full text search across multiple tables
body: <p>I have a series of tables that contain data I want to full text search. I've tried combining the tables with <code>UNION</code>, but the result loses its fulltext index so can't be fulltext searched. I don't think that putting the data into a temp table is the way to go. Is there someway that I can fulltext search these tables efficiently? Thanks in advance!</p>
  
  <p><b>UPDATE:</b>
  my query for fulltext was<br></p>
  
  <pre><code>SELECT ID, Title, Description, Author, MATCH (Title,Tags,Body) AGAINST ("search terms") AS Relevance 
  FROM [combination of tables goes here] 
  WHERE MATCH (Title,Tags,Body) AGAINST ("search terms")
  </code></pre>