fetch data using query builder by checking multiple data from same column in laravel

Question

DB::table('products')
->where('status', '=', 'published')
->where('sub_category', '=', 'grooming-wellness')
->where('sub_category', '=', 'beauty-care')
->get();

it doesn't work. it returns 0 data.

What is your goal?

AH.Pooladvand
– AH.Pooladvand

2019-12-11 10:38:40 +00:00
Commented Dec 11, 2019 at 10:38 — AH.Pooladvand
– AH.Pooladvand, Commented Dec 11, 2019 at 10:38

lagbox · Accepted Answer · 2019-12-11 10:09:36Z

4

I am assuming you want to check if a field has a particular value or another value. You can use whereIn to achieve this:

DB::table('products')
    ->where('status', '=', 'published')
    ->whereIn('sub_category', ['grooming-wellness', 'beauty-care'])
    ->get();

Laravel 6.x Docs - Query Builder - Where Clauses - Additional Where Clauses whereIn

edited Dec 11, 2019 at 10:09

answered Dec 11, 2019 at 10:08

lagbox

50.7k8 gold badges76 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

fetch data using query builder by checking multiple data from same column in laravel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related