How can i use group_concat of mysql in PHQL?

Hi There,

When i am using group_concat in PHQL, it gives me following error.

Syntax error, unexpected token IDENTIFIER

How can i use group_concat function in PHQL. It works fine in raw sql.

GROUP_CONCAT is non-standard sql, so you'll have to implement it in a db adapter dialect:



Hi there,

Thank you for reply.

group_concat() works if i do not specify separators. for example

This work in PHQL.

select GROUP_CONCAT(username) from Users;

But this wont works in PHQL.

select GROUP_CONCAT(username SEPARATOR ':') from Users;

Why this happens?Any idea about it?