MySQL – GROUP_CONCAT

SELECT type as result FROM tbl_users

Result:
admin
admin
user
admin
editor

SELECT GROUP_CONCAT(type) as result FROM tbl_users

Result:
admin,admin,user,admin,editor

https://database.guide/how-to-return-query-results-as-a-comma-separated-list-in-mysql/

MSSQL equivalent is STRING_AGG()

This entry was posted on Wednesday, March 6th, 2019 at 8:41 amand is filed under MYSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.