MySQL has useful extention to the GROUP BY operation – function GROUP_CONCAT: GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group. Returns NULL when there are no non-NULL values. Where it can be useful? For example to get array without looping inside the code, In single SQL query …
Tag: Mysql grouping
Permanent link to this article: https://blog.openshell.in/2013/05/mysql-group_concat/