Nested query using a relationship column

Hello guys, I have this default query

$products =  Product::with('category', 'skus');

after some conditions i am extending my query like this

$search = "SOMETHING"
$products->where(function ($q) use ($search) {
                $q->where("name", "like", "%$search%")
                    ->orWhere("price", "like", "%$search%");
                 //->orWhere("category.name", "like", "%$search%");
            });

but the last condition

->orWhere("category.name", "like", "%$search%");

doesnt work. How can I use relationship column in nested query :(

Thanx for any advice

staudenmeir

7 years ago

Best Answer

Level 24

Use whereHas():

->orWhereHas('category', function($query) use($search) {
    $query->where('name', 'like', "%$search%");
});

1 like

kari

7 years ago

Level 1

@STAUDENMEIR - Thanks man :)

Please or to participate in this conversation.