LARAVEL use Lists result as a parameter

Question

I need some help to do this query in laravel.

Select id from tableone where id in (1,2,3,4,5)

The (1,2,3,4,5) must be a result from another query.

 This >>> $s = TableOne::lists('id');
 Result >>> ["4","14", "11", "1", "13", "3", "2"]

How do I do this?

In Laravel 5.3 `lists` will be deprecated. It has been renamed to `pluck`. Use `pluck` instead for future proofing. — DutGRIFF, Jan 15 '16 at 15:44

score 1 · Accepted Answer · answered Apr 06 '15 at 12:05

1

You can use wherein function in Laravel.

$s = AnotherTable::lists('id'); // get ids from another query
$users = TableOne::whereIn('id', $s)->get(); // pass array of ids into it

answered Apr 06 '15 at 12:05

mininoz

1 Answers1