How to Use The whereIn() and whereNotIn() Laravel Methods - Mastering Eloquent & Collection Methods

In this tutorial, we will cover the whereIn() and whereNotIn() methods in Laravel Collections. These Laravel methods allow you to filter a collection based on multiple values, and are useful when you have an array of values and want to find all the records in a collection that match one or more of those values. We will demonstrate how these methods work by using the User model to find all users that have a certain role, and excluding specific values from our query. These Laravel methods are powerful because they allow you to find records that match or do not match any value in the array, and you can use them to find all the records in one query, making your code more readable and maintainable. We will also show you how to chain these methods with others to customize your queries. 📚 New Udemy Course If you’re looking to level up your Laravel skills? My new course “Mastering Laravel 10 Query Builder, Eloquent & Relationships“ is the perfect opportunity. Learn the essential tools and techniques for building robust and scalable web applications with Laravel: 📲 Let’s plan a meeting Plan a (paid) 1-hour meeting on Calendly to do portfolio reviews, code reviews resume reviews, or a coaching session for Laravel: 💌 Newsletter Sign up for my free weekly email newsletter: 🔥 Resources - Twitter: - Instagram: - Blog: - Patreon: - GitHub: - TikTok: @codewithdary 📋 Table of Content 00:00 -whereIn() 02:01 - whereNotIn() 03:46 - Outro #laravel #php #codewithdary