如果可能的话,我需要为 MySQL 5.7 构建一个 SQL 查询,以“ GROUP BY
”uid
和title
连接permissions
列并用 ? 分隔。|
我是说GROUP BY
,但我不知道这是否是正确的术语。
+------+--------+------------------------------------------------+
| uid | title | permissions |
+------+--------+------------------------------------------------+
| 1438 | Delete | /_permission_set.php|/process.php|/command.php |
+------+--------+------------------------------------------------+
| 1438 | Remove | /_permission_set.php|/process.php|/command.php |
+------+--------+------------------------------------------------+
我尝试了以下 SQL(正如您在DBFiddle中看到的那样),但它不起作用
SELECT uid, CONCAT('|', permissions)
FROM some_table
WHERE uid=1438
GROUP BY uid, permissions;
小提琴