how to do GROUP_CONCAT using Hydrahon

[dht20]

im trying to do

SELECT id , GROUP_CONCAT(name) like this select("id, GROUP_CONCAT(name) ")

but i getting problemes , how can i do it properly?

[mario-deluna]

Hello there,

You can use the Func or Expression object.

use ClanCats\Hydrahon\Query\Sql\Func;

$h
    ->table('stats')
    ->select(['id', new Func('GROUP_CONCAT', 'name')])
    ->execute();

Result:

select `id`, GROUP_CONCAT(`name`) from `stats`