title: Mixed MySQL and Sphinx queries
body: <p>I have MySQL and Sphinx installed and working properly on a LNMP server. Now I'd like to integrate a Sphinx sub-query into an existing MySQL query.</p>
  
  <p>Example:</p>
  
  <pre><code>SELECT * FROM mysql_table
  JOIN (SELECT id FROM sphinx_index MATCH ('keyword')) AS match_table
  ON match_table.id = mysql_table.id
  </code></pre>
  
  <p>Is this possible? If not, should I do the Sphinx separately and then use <code>WHERE IN</code> in the MySQL query, or will this kill the extra efficiency I'm getting from Sphinx?</p>