title: How to call a mysql in clause with a value match as well?
body: <p>I have this query going and it return an empty array when in fact the two users are in the same Group_Members table. This is the query I put together to find mutual groups between two people.</p>
  
  <pre><code>"SELECT g.title, g.id FROM Groups g LEFT JOIN Group_Members g_m ON g.id = g_m.group_id WHERE g_m.user_id = ? AND g_m.group_id IN (?) ORDER BY g.id";
  </code></pre>
  
  <p>The array for the in is [1, 6, 8] and id 8 is the one that is expected to be returned.</p>
  
  <p>Anyone able to let me know if I am messing something up.</p>