How can a filter be made with having()

[dertin]

Hello, the following is what I want to do:

SELECT *
FROM testing
GROUP BY foo
HAVING COUNT(foo) > 1

but it does not work.

$mapperTesting->all()->group(['foo'])->having(['COUNT(foo)' => '> 1'])->toArray();

Regards,

[FlipEverything]

I am really sorry for the late reply, but have you tried this?

$mapperTesting->all()->group(['foo'])->having(['COUNT(foo) >' => '1'])->toArray();

It translates to:

GROUP BY test_posts.status HAVING COUNT(status) >  ?