如何使用Laravel Eloquent Query Builder进行此查询

Question

if I have

SELECT * FROM slab WHERE 500 >= min_rate and 500 <= max_rate

How can I run this query in Laravel Eloquent way.

Answer 1

Eloquent:

Slab::where('min_rate', '<=', 500)->where('max_rate', '>=', 500)->get();

Query Builder:

DB::table('slab')->where('min_rate', '<=', 500)->where('max_rate', '>=', 500)->get();