title: How to select all values, not just those in where clause
body: <p>I have a query that looks like this:</p>
  
  <pre><code>SELECT id, GROUP_CONCAT(type SEPARATOR ',') AS type FROM rock_types 
          WHERE type IN("DWS","Top rope") GROUP BY id
  </code></pre>
  
  <p>this returns all the ids that have a type of DWS or top rope or both with the types concatenated. However, there are more types than just those 2. Is it possible to still select only ids that  have DWS or top rope or both, but also select all the other types associated with those ids? Thanks!</p>