title: LIMIT subquery in mysql
body: <p>I am trying to run the next query, but I get this error:</p>
  <blockquote>
  <p>This version of MySQL doesn't yet support 'LIMIT &amp; IN/ALL/ANY/SOME
  subquery'</p>
  </blockquote>
  <pre><code>SELECT * FROM retail
  WHERE session_code IN (
  SELECT session_code FROM retail
  WHERE utterance REGEXP '...' AND NOT utterance REGEXP '...' 
  LIMIT 100
  );
  </code></pre>
  <p>I found an answer in other thread saying to use JOIN but I can't make it work help! :S</p>
  <p>thanks!</p>