Laravel query where subquery

Question

I am looking for the best way to perform the query below as a Laravel 4.2 query. I am struggling on the where clause which has a sub query to work.

What my query is doing: I have a parent table with a 1-many child table. I want to get a list of all the child records associated to the parent record only knowing a current child record.

select child.id, child.jobNumber
from child
where child.parentId = (select child.parentId from child where child.id = 2)
order by child.jobNumber, child.id

Something like:

$query = DB::table('child');
$query->select(array('child.id','child.jobNumber'));
$query->orderBy('child.jobNumber');
$query->orderBy('child.id');

// how do I do my where clause?

$list = $query->get();

This will be helpful stackoverflow.com/questions/27064678/laravel-eloquent-subquery — Akshendra Pratap
– Akshendra Pratap, Commented Oct 19, 2015 at 20:27

rand0mb1ts · Accepted Answer · 2015-10-19 20:29:55Z

1

What about using whereRaw? http://laravel.com/docs/4.2/queries#advanced-wheres

$query = DB::table('child');
$query->select(array('child.id','child.jobNumber'));
$query->whereRaw('child.parentId = (select child.parentId from child where child.id = 2)');
$query->orderBy('child.jobNumber');
$query->orderBy('child.id');

// how do I do my where clause?

$list = $query->get();

answered Oct 19, 2015 at 20:29

rand0mb1ts

2294 silver badges18 bronze badges

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

Collectives™ on Stack Overflow

Laravel query where subquery

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related