How to use GROUP BY to concatenate strings in MySQL?

by 
SELECT id, GROUP_CONCAT(name SEPARATOR ' ') FROM table GROUP BY id;

https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html#function_group-concat

From the link above, GROUP_CONCAT: This function returns a string result with the concatenated non-NULL values from a group. It returns NULL if there are no non-NULL values.

More Related Contents:

  1. MySQL Results as comma separated list
  2. String concatenation does not work in SQLite
  3. Splitting string into multiple rows in Oracle
  4. Simple way to calculate median with MySQL
  5. Unioning two tables with different number of columns
  6. NULL in MySQL (Performance & Storage)
  7. MySQL function to find the number of working days between two dates
  8. MySQL Trigger to prevent INSERT under certain conditions
  9. MySQL “NOT IN” query
  10. Emulate MySQL LIMIT clause in Microsoft SQL Server 2000
  11. Importance of varchar length in MySQL table
  12. mySQL :: insert into table, data from another table?
  13. Return 0 if field is null in MySQL
  14. How can multiple rows be concatenated into one in Oracle without creating a stored procedure? [duplicate]
  15. MySQL “between” clause not inclusive?
  16. What’s the best way to capitalise the first letter of each word in a string in SQL Server
  17. SQL – How to transpose?
  18. SQL string comparison, greater than and less than operators
  19. Splitting the string in sql server
  20. MySQL concatenation operator
  21. SQL SELECT to get the first N positive integers
  22. MySql – Way to update portion of a string?
  23. Multiple Ranks in one table
  24. Counting the number of occurrences of a substring within a string in PostgreSQL
  25. The difference between ‘AND’ and ‘&&’ in SQL
  26. Converting String List into Int List in SQL
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. sql pulling a row for next or previous row of a current row
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment