How to Aggregate Strings into a List in MySQL (Similar to Oracle's LISTAGG)?

Aggregate Function in MySQL: Aggregate Values into a List (Similar to LISTAGG in Oracle)

Query:

I need function, that returns list of strings.

I have data in table like this:

Id    MyString
------------------------
 1    First
 2    Second
 3    Third
 4    Fourth

I need function like this (something like this works in oracle):

select LISTAGG(MyString, ', ') as myList where id <p><strong>Answer:</strong></p><p>MySQL provides the GROUP_CONCAT() function for this purpose. It aggregates values into a comma-separated list.</p><p><strong>Query Using GROUP_CONCAT():</strong></p><pre class="brush:php;toolbar:false">select group_concat(MyString separator ', ') as myList 
from table
where id <p>This query will return a list of strings, separated by commas, for all rows where the id is less than 4. The 'myList' column will contain the aggregated result.</p><p><strong>Note:</strong> The GROUP_CONCAT() function allows for grouping by multiple columns if necessary. For example:</p><pre class="brush:php;toolbar:false">select group_concat(MyString separator ', ') as myList 
from table
where id <p>This query will group the results by the another_column column and create a list of strings for each group.</p>

The above is the detailed content of How to Aggregate Strings into a List in MySQL (Similar to Oracle's LISTAGG)?. For more information, please follow other related articles on the PHP Chinese website!