title: Return array of values with MYSQL SELECT
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/2524848/can-mysql-nested-select-return-list-of-results">Can MySQL Nested Select return list of results</a>  </p>
  </blockquote>
  
  
  
  <p>I have one table containing the <code>users</code> (id, name) and another one containing <code>courseAttrs</code> a user has applied to (userID,courseID). I would like to select all users and have this select return the name and a comma separated list of courseIDs the user has applied to. What is a possible solution?</p>