Can we use whereIn clause with not equal

Question

I need to do following

Model::select('column')->whereIn('column','!=',array)->first();

So how can i achieve this. Any suggestions Thank you.

not if you put `,array)` in there (probably a syntax error as array is a keyword in PHP). Well I don't use Laravel, but I can tell that probably wont do what you want. Maybe it's just a typo in the question? — ArtisticPhoenix, Mar 07 '19 at 06:52
You can use `whereNotIn('column', $array)`. You can check out docs @ https://laravel.com/docs/5.8/queries#where-clauses — Iftikhar uddin, Mar 07 '19 at 07:34

score 9 · Accepted Answer · answered Mar 07 '19 at 06:57

9

Instead of whereIn you can use whereNotIn.

Like this:

Model::select('column')->whereNotIn('column', array(1,2,3))->first();

answered Mar 07 '19 at 06:57

Inzamam Idrees

If it's working, please accept as a right answer for other users to give help. – Inzamam Idrees Mar 07 '19 at 10:47

score 4 · Answer 2 · answered Mar 07 '19 at 06:56

4

You are looking for whereNotIn('column', $array). See the Queries documentation for more methods.

answered Mar 07 '19 at 06:56

FatBoyXPC

score 4 · Answer 3 · answered Mar 07 '19 at 06:58

4

Use

Model::whereNotIn('id',[10,20])->select('id')->first();

answered Mar 07 '19 at 06:58

bhavinjr

score 3 · Answer 4 · answered Mar 07 '19 at 07:42

3

try this:

Model::select('column')->whereNotIn('column',array)->first();

answered Mar 07 '19 at 07:42

PHP Geek

4 Answers4