title: mysql intersect
body: <p>I'm new to mysql so please be kind. I'm getting the following error for my script and im not sure whats wrong with it.</p>
  
  <pre><code>SELECT uoid 
  FROM mint 
  WHERE mint_id='6' and userid='3836'
  INTERSECT 
  SELECT id as uoid
  FROM cats 
  WHERE category='Health, Fitness' 
  ORDER BY 1;
  </code></pre>
  
  <p>gives</p>
  
  <pre><code>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INTERSECT SELECT id as uoid FROM cats WHERE category='Health, Fitness'' at line 4
  </code></pre>