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
Listing::select('listings.*')
                 ->whereBetween('price', [200, 500])
                 ->groupBy('listings.id')
                 ->orderBy('listings.id', 'desc')
                 ->paginate(1000);
did I wrong somewhere ? It just show only 1 result ?
thank you for your helps!
via Chebli Mohamed
 
Aucun commentaire:
Enregistrer un commentaire