How to use an array in where clause in MySQL query in Laravel

Question

I have an array $time_schedule_id= array(1,3,5). Now I want those data which are not matched with the given array ( $time_schedule_id= array(1,3,5) ) from $time_schedule_table.

DB::table('time_schedule_table')
select('*')
where('id','!=', ?)

How can I generate this query string to use with MySQL?

Look at https://stackoverflow.com/questions/25849015/laravel-eloquent-where-not-in — Rooneyl, Feb 27 '18 at 09:05

score 1 · Accepted Answer · answered Feb 27 '18 at 09:07

1

You can use laravel whereNotIn() eloquent function

DB::table('time_schedule_table')->select(*)->whereNotIn('id', [1,3,5])->get();

answered Feb 27 '18 at 09:07

Ayaz Ali Shah

3,453
9
36
68

@Mr.Developer......absolutely right – raff Feb 28 '18 at 09:43

How to use an array in where clause in MySQL query in Laravel

1 Answers1