Laravel Eloquent “WHERE NOT IN”

by

Query Builder:

DB::table(..)->select(..)->whereNotIn('book_price', [100,200])->get();

Eloquent:

SomeModel::select(..)->whereNotIn('book_price', [100,200])->get();

More Related Contents:

  1. Migration: Cannot add foreign key constraint
  2. Laravel Eloquent groupBy() AND also return count of each group
  3. Eloquent Collection: Counting and Detect Empty
  4. Eloquent eager load Order by
  5. Laravel. Use scope() in models with relation
  6. How to access model hasMany Relation with where condition?
  7. Eloquent push() and save() difference
  8. Laravel save / update many to many relationship
  9. First Or Create
  10. Laravel: Returning the namespaced owner of a polymorphic relation
  11. Polymorphic Eloquent relationships with namespaces
  12. Clone an Eloquent object including all relationships?
  13. Laravel redirect back to original destination after login
  14. How to select from subquery using Laravel Query Builder?
  15. How can I resolve “Your requirements could not be resolved to an installable set of packages” error?
  16. Laravel Redirect Back with() Message
  17. Laravel Fluent Query Builder Join with subquery
  18. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  19. HasManyThrough with one-to-many relationship
  20. Getting just the latest value on a joined table with Eloquent
  21. Laravel Migration Change to Make a Column Nullable
  22. Laravel Controller Subfolder routing
  23. Update without touching timestamps (Laravel)
  24. Best Practices for Laravel 4 Helpers and Basic Functions?
  25. Laravel 4: Failed to open stream: Permission denied
  26. Find or Create with Eloquent
  27. Laravel: Change base URL?
  28. How to setup conditional relationship on Eloquent
  29. Laravel Eloquent – Where In All
  30. Laravel 4 : Route to localhost/controller/action

Leave a Comment