Grouping multiple where clauses with OR in Laravel on one single orWhere function

Question

I want to select from the database something like: SELECT * FROM database WHERE id=1 OR id=2 OR id=5;

I do not know the number of the where clauses that the user will request, it can be one, it can be 10.

I tried using Model::orWhere([['id','=',1],['id','=',2],['id','=',5]]) but it seems to be returning an empty list.

In the Laravel documentation, there is this example for the WHERE clause:

users = DB::table('users')->where([
    ['status', '=', '1'],
    ['subscribed', '<>', '1'],
])->get();

While the WHERE clause it working as in the example, orWhere clause doesn't seem to work like this though.

You could use and IN Clause https://stackoverflow.com/questions/29115385/how-to-make-laravel-eloquent-in-query — rbaskam, Jun 26 '17 at 08:32
Does `SELECT * FROM database WHERE id=1 OR id=2 OR id=5;` works for you ? — Mayank Pandeyz, Jun 26 '17 at 08:32
@MayankPandeyz yes, I tested the clauses on something that should return. — Alexandru Antochi, Jun 26 '17 at 08:35
If you have solved your problem, then please close the question — rbaskam, Jun 27 '17 at 08:07

score 2 · Answer 1 · answered Jun 26 '17 at 08:36

2

Use something like:

User::whereIn('id', [1, 2, 3])->get();

As second parameter you need to use an array.

answered Jun 26 '17 at 08:36

Patryk Woziński

rbaskam · Accepted Answer · 2017-06-26T12:14:42.843

2

Following on from my comment you can us an IN Clause could solve this.

$model = Model::whereIn('id', array(1, 2, 3))->get();

edited Jun 26 '17 at 12:14

answered Jun 26 '17 at 08:36

rbaskam

2 Answers2