Laravel Eloquent Query Where IN statement

Question

How do I convert this MySQL query to Laravel Eloquent Query:

SELECT * FROM service_package WHERE price IN ('110010', 'Test 02', '11009')

Vikash Pathak · Accepted Answer · 2019-06-26 12:42:59Z

2

You can use the whereIn() like:

$data = \DB::table("service_package")
               ->whereIn("price", ['110010', 'Test 02', '11009'])
               ->get();

$data = App\ServicePackage::whereIn("price", ['110010', 'Test 02', '11009'])
               ->get();

Here, make sure you have created model ServicePackage for the table service_package.

answered Jun 26, 2019 at 12:35

Vikash Pathak

3,6321 gold badge22 silver badges33 bronze badges

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

1 Answer 1