Hey everyone, in this video I’m showing a small but really nice feature that landed in Laravel 10.47.0: the new whereAny and whereAll query builder methods. I start by running a simple “get users” query so you can see what’s happening in the SQL, and then I move into a very common scenario—searching users by a text like “Laratips” across multiple columns like name, email, and the about section. Before this release, if you wanted to match “any of these columns contains this text”, you typically had to write a nested where with multiple orWhere calls—basically repeating yourself three times. Now with whereAny, I can pass an array of columns (name, email, about) and apply the same operator/value once, and Laravel generates the same SQL with the OR conditions for me. On the other side, whereAll is for when you want all columns to match—Laravel will generate AND conditions instead of OR. So if you need users where the type is normal and they must have “Laratips” in both name and about, whereAll makes that super clean. It’s a simple change, but it keeps your queries readable and your code much cleaner.