Laravel Eloquent WHERE NOT IN

Question

I m having trouble to write query in laravel eloquent ORM    my query is   SELECT book name dt of pub pub lang no page book price   FROM book mast         WHERE book price NOT IN  100 200     Now I want to convert this query into laravel eloquent

User · Answer

You can use WhereNotIn in following way also   ModelName  whereNotIn  book price    100 200  - gt get   field name1   field name2       This will return collection of Record with specific fields

User · Answer

You can use this example for dynamically calling the Where NOT IN   user   User  where  company id        1 - select  id - get  - toArray      otherCompany   User  whereNotIn  id    user - get

User · Answer

This is my working variant for Laravel 7 DB  table  user                      - gt select  id   name     - gt whereNotIn  id   DB  table  curses  - gt where  id user    id - gt pluck  id user  - gt toArray      - gt get

User · Answer

You can use WhereNotIn in the following way    category DB  table  category             - gt whereNotIn  category id   14  15             - gt get    enter code here

User · Answer

I had problems making a sub query until I added the method - gt toArray   to the result  I hope it helps more than one since I had a good time looking for the solution   Example  DB  table  user                      - gt select  id   name     - gt whereNotIn  id   DB  table  curses  - gt select  id user  - gt where  id user         id - gt get  - gt toArray      - gt get

User · Answer

Query Builder   DB  table    - gt select    - gt whereNotIn  book price    100 200  - gt get      Eloquent   SomeModel  select    - gt whereNotIn  book price    100 200  - gt get

User · Answer

The dynamic way of implement whereNotIn     users   User  where  status  0 - gt get        foreach   users as  user                     data      user- gt id                     available   User  orderBy  name    DEC  - gt whereNotIn  id    data - gt get

User · Answer

The whereNotIn method verifies that the given column s value is not contained in the given array    users   DB  table  users                       - gt whereNotIn  id    1  2  3                       - gt get

User · Answer

You can do following   DB  table  book mast    - gt selectRaw  book name dt of pub pub lang no page book price     - gt whereNotIn  book price   100 200

User · Answer

Its simply means that you have an array of values and you want record except that values records   you can simply pass a array into whereNotIn   laravel function   With query builder   users   DB  table  applications                       - gt whereNotIn  id    1 3 5                        - gt get      will return without applications which contain this id s   With eloquent    result   ModelClassName  select  your column name  - gt whereNotIn  your column name     satatus1    satatus2       return without application which contain this status

User · Answer

created po   array          challan   modelname  where  fieldname        0 - gt get            dd  challan        foreach   challan as  rec             created po     array push  created po  rec- gt fieldname                data   modelname  whereNotIn  fieldname   created po - gt orderBy  fieldname   desc  - gt with  modelfunction  - gt get

[laravel] Laravel Eloquent "WHERE NOT IN"

Examples related to laravel

Examples related to laravel-4

Examples related to eloquent