title: SQL query of multiple values in one cell
body: <p>There is a table(Course Interests) which has all the values in one cell. But those values are just ids and I want to join them with another table(Course) so I can know their names.</p>
  
  <p>Course Interests:</p>
  
  <pre><code>MemberID          MemberName              CoursesInterested
  --------------    ---------------------   --------------
  1                  Al                     1,4,5,6
  2                  A2                     3,5,6
  </code></pre>
  
  <p>Course Table:</p>
  
  <pre><code>CourseId          Course
  --------------    ---------------------
  1                 MBA 
  2                 Languages
  3                 English
  4                 French
  5                 Fashion
  6                 IT
  </code></pre>
  
  <p>Desired Output:</p>
  
  <pre><code>MemberID          MemberName              CoursesInterested
  --------------    ---------------------   --------------
  1                  Al                     MBA,French,Fashion,IT
  2                  A2                     English,Fashion,IT
  </code></pre>
  
  <p>I would like to do a SQL query in MySql that can help me to extract the desired output. I know how to do it in the opposite way(join values to one cell), but I've struggling on seek a way to separate the ids and do a cross-join into another table. </p>
  
  <p>I'll appreciate any help from the community. Thanks</p>