title: How can I display one Mysql row to multiple rows?
body: <p>I need some help please.
  I have this simple mysql query:</p>
  
  <pre><code>select '1,2,3,4,5,6' as Col1 from dual;
  </code></pre>
  
  <p>and the table1: </p>
  
  <pre><code>Col1
  1,2,3,4,5,6
  </code></pre>
  
  <p>And I have another table2: </p>
  
  <pre><code>service_id    service_name
  1             Service1
  2             Service2
  </code></pre>
  
  <p>I tried next query but not working:</p>
  
  <pre><code>select service_name from table2 where service_id in (select col1 from table1)
  </code></pre>
  
  <p>Any help would be appreciated!</p>