title: MySql Group Concat - Don't want rows excluded from Where clause
body: <p>Okay, so I have a case where I want to do a Group Concat, but also use the same column that's in the Group Concat as a Where clause further in the statement, but <strong>not exclude</strong> the results in the Group Concat because of the Where. Got it? Hahah here's what I mean:</p>
  
  <pre><code>SELECT posts.id, post.post_date, 
    GROUP_CONCAT(DISTINCT terms.name ORDER BY terms.name DESC SEPARATOR ';')
  FROM posts
  INNER JOIN terms on terms.post_id = posts.id
  WHERE terms.name = "kittens";
  </code></pre>
  
  <p>So I want to get the posts where the post's terms.name = "kittens", however the post can have multiple terms.name, such as "kittens", "cats", "cuteness", etc etc. So in the Group Concat I want the result to be "kittens;cats;cuteness" (each of these being a separate entry related by posts.id). However with "kittens" in the Where clause, all the Group Concat returns is "kittens". </p>
  
  <p>If I said "WHERE terms.name = 'kittens' OR terms.name = 'cats'", the Group Concat returns "kittens;cats"... but I only want to be searching by one terms.name and get the rest of the terms in the Group Concat.</p>
  
  <p>How can I get around this?</p>