Laravel whereIn issue

Question

Good day,

I wanted to do something like this:

$ids = [1, 2, 3];
$posts = $user->posts()->whereIn('id', $ids)->get();

but I get an Internal Server Error. Is there a different way to do this?

For the sake of this example, assume ID is not the primary key and that multiple posts can have the same ID. So this:

$ids = [1, 2, 3];
$posts = Post::whereIn('id', $ids)->get();

wouldn't return the desired results.

You can also try to do this `$posts = Post::whereIn('id', arr)->toSql();` and check if the query is being build successfully — Sérgio Reis, Apr 17 '18 at 09:04
Possible duplicate of [Laravel whereIn OR whereIn](https://stackoverflow.com/questions/22758819/laravel-wherein-or-wherein) — Pradeep, Apr 17 '18 at 09:04
Yes, I meant to say $ids. I get the error on the second line of the first code. — Lukho Mdingi, Apr 17 '18 at 09:04

Sohel0415 · Accepted Answer · 2018-04-17T09:23:09.847

3

The reason you are having the error is mysql is unable to what table you are referring with id column. Use tableName in whereIn() clouse

$posts = $user->posts()->whereIn('posts.id', $ids)->get();

N.B: I assume your Post table name is posts

edited Apr 17 '18 at 09:23

answered Apr 17 '18 at 09:10

Sohel0415

9,523
21
30

can somebody explain me why downvoting in this answer? – Sohel0415 Apr 17 '18 at 09:19
This helped. Thank you. I'm not the one who voted down. – Lukho Mdingi Apr 17 '18 at 09:21
the reason you are having the error is mysql is unable to what table you are referring with id column – Sohel0415 Apr 17 '18 at 09:22
@LukhoMdingi see my updated answer, it will give you clear idea about the problem you are having – Sohel0415 Apr 17 '18 at 09:24

Affan · Answer 2 · 2018-04-17T09:19:26.903

0

please use like

  $items = DB::table('items')->whereIn('id', [1, 2, 3])->get();

link : Laravel ->where('id', ARRAY). multiple where conditions laravel 4

And

  User::select('id','name','email','phone','created_at')->whereIN('id',[1,2,3,4,5,6,7,8,9,9,10,11])->where('is_guest',NULL)->where('user_type','1')->orderBy('id','desc')->take(20)->get();

also work with laravel 5.4

edited Apr 17 '18 at 09:19

answered Apr 17 '18 at 09:13

Affan

1,132
7
16

I didn't get to try this one. @Sohel0415's answer worked. Thank you for your contribution. – Lukho Mdingi Apr 17 '18 at 09:23

Laravel whereIn issue

2 Answers2