title: PostgreSQL's array_agg() and array_to_string in MySQL
body: <p>I wonder if there's a counterpart of <code>array_agg()</code> and <code>array_to_string</code> of <code>PostgreSQL</code> in <code>MySQL</code> (Or anything close to this function at least) I haven't had any luck on my research trying to find something similar to this two. For non-PostgreSQL users, here's how it works.<br>
  Normally, executing:</p>
  
  <pre><code>SELECT my_column FROM my_table;
  </code></pre>
  
  <p>Will result to:</p>
  
  <pre><code>--------------
  | my_column  |
  |------------|
  |   DATA1    |
  |   DATA2    |
  |   DATA3    |
  |   DATA4    |
  --------------
  </code></pre>
  
  <p>On the other hand, executing the statement:</p>
  
  <pre><code>SELECT array_agg(my_column) FROM my_table;
  </code></pre>
  
  <p>Will result to:<br>
  A single row with all the data from my_column.</p>
  
  <pre><code>-----------------------------------
  |       array_agg(my_column)      |
  |---------------------------------|
  |{"DATA1","DATA2","DATA3","DATA4"}|
  -----------------------------------
  </code></pre>
  
  <p>And array_to_string, as the function name says, it converts the array into a single String.
  <br>
  Converting the array_agg(my_column) will return the following:<br></p>
  
  <pre><code>-------------------------
  |                       |
  |-----------------------|
  |DATA1,DATA2,DATA3,DATA4|
  -------------------------
  </code></pre>
  
  <p>Depending on your separator. In my case, it's comma.<br><br>
  <strong><em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>***</strong><em>Edit(SOLUTION)<strong></em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>**<em>*</em>*</strong>
  <br><br>
  Solution (Written by IgorRomanchenko):<br><br></p>
  
  <pre><code>SELECT GROUP_CONCAT(my_column SEPARATOR ',');
  </code></pre>