Skip to main content
4 votes
Accepted

How can I get all results concatenated from a column group by UID?

SELECT uid, title, GROUP_CONCAT(permissions SEPARATOR '|') FROM some_table WHERE uid=1438 GROUP BY uid, title; uid title GROUP_CONCAT(permissions SEPARATOR '|') 1438 Delete /_permission_set.php|/...
Akina's user avatar
  • 20.1k

Only top scored, non community-wiki answers of a minimum length are eligible