convert SELECT query from mySql to Laravel query builder

Question

what would be Laravel Query Builder code of this mysql query;

SELECT * 
FROM Student
WHERE family_id IN (SELECT family_id 
                    FROM students 
                    GROUP BY family_id 
                    HAVING COUNT(1)>1)
ORDER BY family_id

I recommend you to use Eloquen Models. Check out the docs — Pepe
– Pepe, Commented Nov 24, 2018 at 2:22

Kelvin · Accepted Answer · 2018-11-24 01:41:46Z

1

$query = DB::select("SELECT * 
FROM Student
WHERE family_id IN (SELECT family_id 
                    FROM students 
                    GROUP BY family_id 
                    HAVING COUNT(1)>1)
ORDER BY family_id")

Based on Laravel Documentation

answered Nov 24, 2018 at 1:41

Kelvin

1,1041 gold badge10 silver badges32 bronze badges

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

Comments

Dhruv Raval · Accepted Answer · 2018-11-24 04:10:34Z

0

Use function in whereIn clause:

Student::whereIn('family_id', function($query) {
   $query->select('family_id')
     ->from(with(new Students)->getTable())
     ->groupBy('family_id')
     ->havingRaw('COUNT(1) > 1')
})->get();

answered Nov 24, 2018 at 4:10

Dhruv Raval

1,5831 gold badge10 silver badges18 bronze badges

Collectives™ on Stack Overflow

convert SELECT query from mySql to Laravel query builder

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related