Hi!
Can I do something like this for group concate?
name1 (username1), name2 (username2), …
I have tried :
GROUP_CONCAT(user.name, ‘(’ + user.username + ‘)’)
but it doesn’t work.
Please help. Thanks.
Hi!
Can I do something like this for group concate?
name1 (username1), name2 (username2), …
I have tried :
GROUP_CONCAT(user.name, ‘(’ + user.username + ‘)’)
but it doesn’t work.
Please help. Thanks.
GROUP_CONCAT(
CONCAT(user.name,' (',user.username,')')
SEPARATOR ', '
)
Thanks!