title: How to: match (search space) against (join with column from other table)
body: <p>I'm lousy at SQL queries so this may be a silly question. However, here is roughly what i'd like to do:</p>
  
  <blockquote>
    <p>table corpuses //stuff i'd like to search thru
       title
       body
       ...</p>
    
    <p>table searches  //list of search terms to be applied to corpuses
       term<br>
       ...</p>
  </blockquote>
  
  <p>The query i'd like to write is more or less as follows: I beleive I need some sort of a join, but I'm not sure just how to do that. Additionally, I'm not sure that the against() operator will take anything aside from a literal - the docs didn't seem to mention either way.</p>
  
  <blockquote>
    <p>select * from corpuses where match
    (title, body) against (select term
    from searches);</p>
  </blockquote>
  
  <p>I'm using MySQL 5</p>
  
  <p>Any thoughts are greatly appreciated.</p>
  
  <p>Thanks!
  Brian</p>