mercredi 3 octobre 2018

How to Searching between min and max prices in Laravel

I know in mysql query it is something like this

SELECT id 
FROM listings 
WHERE id  IN (
  SELECT id
  FROM listings
  WHERE price between 200 and 500
);

in laravel query I tired

->whereBetween('price', [200, 500])

did I wrong somewhere ? It just show only 1 result ?

thank you for your helps!



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire