How do I code this SQL query in Laravel? Correct way to code mySQL HAVING

Question

The SQL statement below returns the right result, however I am having trouble converting this to Laravel and finding the right way to code Count(*) >=2 .

SELECT  `column_id` 
FROM  `table` 
WHERE  `game_id` 
IN ( 13, 14 ) 
GROUP BY  `column_id` 
HAVING COUNT( * ) >=2

Thanks for the vote of confidence... It took me three hours to work out how to write the correct SQL query!!!, I could add to the post if you want with all the failed attempts to get this code working in laravel, if you believe it is of use? — user3789803
– user3789803, Commented Aug 13, 2014 at 8:37

Javi Stolz · Accepted Answer · 2014-08-13 08:33:22Z

1

Use havingRaw()

DB::table('table')
->select('column_id')
->whereIn('game_id', array(13, 14))
->groupBy('column_id')
->havingRaw('COUNT(*) >=?', array(2))
->get();

answered Aug 13, 2014 at 8:33

Javi Stolz

4,7531 gold badge32 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3789803 Over a year ago

Thank you ->havingRaw() was what I was looking for :-)

Collectives™ on Stack Overflow

How do I code this SQL query in Laravel? Correct way to code mySQL HAVING

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related