title: MySQL:How to show data from 1 column which separated by comma?
body: <p>Dear all, i want to show some data in one row from 1 column and also separated by comma.
  if I do the regular <code>SELECT</code> method, it must be show as the long rows.</p>
  
  <pre><code>SELECT Serial_number FROM data
  
  +-------------+
  |Serial_number|
  +-------------+
  |0001         |
  |0002         |
  |0003         |
  +-------------+ //and so on
  </code></pre>
  
  <p>How do i do to show result as:</p>
  
  <pre><code>+------------------------------+
  |Serial_number                 |
  +------------------------------+
  |0001,0002,0003,....and so on  |
  +------------------------------+
  </code></pre>
  
  <p>thanks for advance.</p>