Convert MySQL Query to Laravel query

Question

I would to convert mysql query to laravel query.

MySQL:

SELECT * FROM scadenze WHERE created_at IN(SELECT MAX(created_at) FROM scadenze GROUP BY processo_id)

Laravel ( i got an error, Object of class stdClass could not be converted to string):

DB::table('scadenze')->whereIn('created_at', DB::select("( SELECT MAX(created_at) FROM scadenze GROUP BY processo_id )"))->get();

Nikola Gavric · Accepted Answer · 2018-02-16 14:42:29Z

2

DB::table('scadenze')->whereIn('created_at', function($query) {
   $query->from('scadenze')
         ->groupBy('processo_id')
         ->select(DB::raw('max(created_at)');
})->get();

edited Feb 16, 2018 at 14:42

answered Feb 16, 2018 at 14:25

Nikola Gavric

3,5331 gold badge10 silver badges16 bronze badges

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

2 Comments

Carmine Rub Over a year ago

New error: Call to undefined method Illuminate\Database\Query\Expression::groupBy()

Nikola Gavric Over a year ago

Try calling groupBy first then select, i've edited my answer

Sangar82 · Accepted Answer · 2018-02-16 14:39:51Z

0

Try with this:

DB::table('scadenze')
    ->whereRaw(DB::raw("created_at IN (SELECT MAX(created_at) FROM scadenze GROUP BY processo_id)"))
    ->get();

I hope this can help!

edited Feb 16, 2018 at 14:39

answered Feb 16, 2018 at 14:26

Sangar82

5,2501 gold badge37 silver badges53 bronze badges

2 Comments

Carmine Rub Over a year ago

I insert variable into dd(); but i got another error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT MAX(created_at) FROM scadenze GROUP BY processo_id' at line 1 (SQL: select * from scadenze where created_at IN SELECT MAX(created_at) FROM scadenze GROUP BY processo_id)

Sangar82 Over a year ago

I've updated my answer, missing parentheses in the IN

Collectives™ on Stack Overflow

Convert MySQL Query to Laravel query

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related