Where Not In using query builder

Question

Similary with this question I need to execute the following Sql query:

SELECT COUNT(*) from table where column NOT IN (SELECT table2.id from table2 where table2.someanothercolumn >0 );

Using Eloquent's query builder, therefore I tried the following (Model Table maps into table table and Model TableTwo maps into table table2):

$enties = Table::where('id',function($q){
  $q->from('table2')->select('id')->where('someanothercolumn','>',0);
})->count();

But on the cide above how I can Place the NOT IN clause?

Dimitrios Desyllas · Accepted Answer · 2019-07-11 09:12:03Z

0

Your answer is in the following snippet of code:

$enties = Table::whereNotIn('id',function($q){
  $q->from('table2')->select('id')->where('someanothercolumn','>',0);
})->count();

In other words just use the whereNotIn.

answered Jul 11, 2019 at 9:12

Dimitrios Desyllas

10.4k17 gold badges89 silver badges203 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Where Not In using query builder

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related