Laravel query subquery

Question

For example I have 2 queries:

1:

$q = SomeContent::select('somecontent_id')
    ->where('slug', Request::segment(2))
    ->where('something', $something)
    ->first();

2

$req = SomeContent::select('slug')
    ->where('something', $anothersomething)
    ->where('somecontent_id', $q->somecontent_id)
    ->first();

How would I merge these together as one query if possible in laravel's query builder? I can't find a lot about using selects statements inside where statements.

Demodave · Accepted Answer · 2015-04-01 14:13:39Z

1

You can union them together, something like

// The query builder also provides a quick way to "union" two queries together:

$q = SomeContent::select('somecontent_id')
    ->where('slug', Request::segment(2))
    ->where('something', $something);

$req = SomeContent::select('slug')
    ->where('something', $anothersomething)
    ->where('somecontent_id', $q->somecontent_id)
    ->union($q)->get();

answered Apr 1, 2015 at 14:13

Demodave

6,7007 gold badges47 silver badges63 bronze badges

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

Comments

perry · Accepted Answer · 2015-04-01 14:51:38Z

1

you could also you the orWhere function

$q = SomeContent::select('somecontent_id')
      ->where('slug', Request::segment(2))
       ->where('something', $something)
        ->orWhere(function($query)
        {
            $query->where('something', $anothersomething)
          ->where('somecontent_id', $q->somecontent_id)
           ->union($q)->get();
        })
        ->get();

answered Apr 1, 2015 at 14:51

perry

112 bronze badges

Collectives™ on Stack Overflow

Laravel query subquery

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